software

Hi All,

I am having trouble opening an excel file. When I go to open it either
by selecting it through the open file menu or double clicking it, the
file opens but the worksheets don't appear. I know it has opened as
the file name is in the menu under quot;windowquot;. Also it is possible to
see the contents of the last cell which was selected as it appears in
the formula bar at the top. The only trouble is the actual worksheets
don't appear in the main window!!

Any ideas on how to fix this? I am using Excel 2000

Many thanks in advance

GW--
giantwolf
------------------------------------------------------------------------
giantwolf's Profile: www.excelforum.com/member.php...oamp;userid=24718
View this thread: www.excelforum.com/showthread...hreadid=526775Try Format gt; Sheets gt; UnhideAll

Vaya con Dios,
Chuck, CABGx3
quot;giantwolfquot; wrote:

gt;
gt; Hi All,
gt;
gt; I am having trouble opening an excel file. When I go to open it either
gt; by selecting it through the open file menu or double clicking it, the
gt; file opens but the worksheets don't appear. I know it has opened as
gt; the file name is in the menu under quot;windowquot;. Also it is possible to
gt; see the contents of the last cell which was selected as it appears in
gt; the formula bar at the top. The only trouble is the actual worksheets
gt; don't appear in the main window!!
gt;
gt; Any ideas on how to fix this? I am using Excel 2000
gt;
gt; Many thanks in advance
gt;
gt; GW
gt;
gt;
gt; --
gt; giantwolf
gt; ------------------------------------------------------------------------
gt; giantwolf's Profile: www.excelforum.com/member.php...oamp;userid=24718
gt; View this thread: www.excelforum.com/showthread...hreadid=526775
gt;
gt;


Thanks but I've tried the Unhide option, nothing is hidden. As I say,
if I pick a cell using the name box I can see the contents of that cell
in the formua bar, I just can't see the worksheet in the main window.--
giantwolf
------------------------------------------------------------------------
giantwolf's Profile: www.excelforum.com/member.php...oamp;userid=24718
View this thread: www.excelforum.com/showthread...hreadid=526775Do you see a worksheet tab at the bottom of the main window?

Will the file open normally on another computer?

Can you open other files normally on this computer?

Do you see Column Letters and Row Numbers? but just a gray field with no
cells defined?....if so try View gt; Normal

With security set to low, does the file require you to authorize
macros?...if so try opening without doing it.

hth
Vaya con Dios,
Chuck, CABGx3quot;giantwolfquot; gt; wrote
in message ...
gt;
gt; Thanks but I've tried the Unhide option, nothing is hidden. As I say,
gt; if I pick a cell using the name box I can see the contents of that cell
gt; in the formua bar, I just can't see the worksheet in the main window.
gt;
gt;
gt; --
gt; giantwolf
gt; ------------------------------------------------------------------------
gt; giantwolf's Profile:
www.excelforum.com/member.php...oamp;userid=24718
gt; View this thread: www.excelforum.com/showthread...hreadid=526775
gt;
I actually just found this problem when I was trying to solve a different
issue and know it was created by checking both the quot;Ignore other
applicationsquot; and quot;Windows in taskbarquot; options at the same time. I'm
funning Office Small business 2000 with Powerpoint 2003.

--
Ramonaquot;CLRquot; wrote:

gt; Do you see a worksheet tab at the bottom of the main window?
gt;
gt; Will the file open normally on another computer?
gt;
gt; Can you open other files normally on this computer?
gt;
gt; Do you see Column Letters and Row Numbers? but just a gray field with no
gt; cells defined?....if so try View gt; Normal
gt;
gt; With security set to low, does the file require you to authorize
gt; macros?...if so try opening without doing it.
gt;
gt; hth
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt; quot;giantwolfquot; gt; wrote
gt; in message ...
gt; gt;
gt; gt; Thanks but I've tried the Unhide option, nothing is hidden. As I say,
gt; gt; if I pick a cell using the name box I can see the contents of that cell
gt; gt; in the formua bar, I just can't see the worksheet in the main window.
gt; gt;
gt; gt;
gt; gt; --
gt; gt; giantwolf
gt; gt; ------------------------------------------------------------------------
gt; gt; giantwolf's Profile:
gt; www.excelforum.com/member.php...oamp;userid=24718
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=526775
gt; gt;
gt;
gt;
gt;


CLR Wrote:
gt; Do you see a worksheet tab at the bottom of the main window?
gt;
gt; Will the file open normally on another computer?
gt;
gt; It has opened normally on my pc before and does open normally on
gt; others.
gt;
gt; Can you open other files normally on this computer?
gt;
gt; Yes
gt;
gt; Do you see Column Letters and Row Numbers? but just a gray field with
gt; no
gt; cells defined?....if so try View gt; Normal
gt;
gt; No, nothing other than the contents of a particular cell in the formula
gt; bar
gt;
gt; With security set to low, does the file require you to authorize
gt; macros?...if so try opening without doing it.
gt;
gt; No macros in this file whatsoever
gt;
gt;
gt; hth
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt; quot;giantwolfquot; gt;
gt; wrote
gt; in message
gt; ...
gt; gt;
gt; gt; Thanks but I've tried the Unhide option, nothing is hidden. As I
gt; say,
gt; gt; if I pick a cell using the name box I can see the contents of that
gt; cell
gt; gt; in the formua bar, I just can't see the worksheet in the main
gt; window.
gt; gt;
gt; gt;
gt; gt; --
gt; gt; giantwolf
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; giantwolf's Profile:
gt; www.excelforum.com/member.php...oamp;userid=24718
gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=526775
gt; gt;

See answers to your questions above. I guess this might remain one of
lifes little mysteries!--
giantwolf
------------------------------------------------------------------------
giantwolf's Profile: www.excelforum.com/member.php...oamp;userid=24718
View this thread: www.excelforum.com/showthread...hreadid=526775
Ramona Wrote:
gt; I actually just found this problem when I was trying to solve a
gt; different
gt; issue and know it was created by checking both the quot;Ignore other
gt; applicationsquot; and quot;Windows in taskbarquot; options at the same time. I'm
gt; funning Office Small business 2000 with Powerpoint 2003.
gt;
gt;Neither of these are checked and it doesn't fix it by checking them and
then unchecking them. Thanks for the suggestion.--
giantwolf
------------------------------------------------------------------------
giantwolf's Profile: www.excelforum.com/member.php...oamp;userid=24718
View this thread: www.excelforum.com/showthread...hreadid=526775