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 "window". 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: http://www.excelforum.com/member.php...o&userid=24718
View this thread: http://www.excelforum.com/showthread...hreadid=526775

Try Format Sheets UnhideAll

Vaya con Dios,
Chuck, CABGx3



"giantwolf" wrote:


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 "window". 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: http://www.excelforum.com/member.php...o&userid=24718
View this thread: http://www.excelforum.com/showthread...hreadid=526775

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: http://www.excelforum.com/member.php...o&userid=24718
View this thread: http://www.excelforum.com/showthread...hreadid=526775

Do 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 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, CABGx3


"giantwolf" wrote
in message ...

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:
http://www.excelforum.com/member.php...o&userid=24718
View this thread: http://www.excelforum.com/showthread...hreadid=526775

I actually just found this problem when I was trying to solve a different
issue and know it was created by checking both the "Ignore other
applications" and "Windows in taskbar" options at the same time. I'm
funning Office Small business 2000 with Powerpoint 2003.

--
Ramona


"CLR" wrote:

Do 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 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, CABGx3


"giantwolf" wrote
in message ...

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:
http://www.excelforum.com/member.php...o&userid=24718
View this thread: http://www.excelforum.com/showthread...hreadid=526775

CLR Wrote:
Do you see a worksheet tab at the bottom of the main window?

Will the file open normally on another computer?

It has opened normally on my pc before and does open normally on
others.

Can you open other files normally on this computer?

Yes

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

No, nothing other than the contents of a particular cell in the formula
bar

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

No macros in this file whatsoever


hth
Vaya con Dios,
Chuck, CABGx3


"giantwolf"
wrote
in message
...

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:
http://www.excelforum.com/member.php...o&userid=24718
View this thread:
http://www.excelforum.com/showthread...hreadid=526775


See answers to your questions above. I guess this might remain one of
lifes little mysteries!


--
giantwolf
------------------------------------------------------------------------
giantwolf's Profile: http://www.excelforum.com/member.php...o&userid=24718
View this thread: http://www.excelforum.com/showthread...hreadid=526775

Ramona Wrote:
I actually just found this problem when I was trying to solve a
different
issue and know it was created by checking both the "Ignore other
applications" and "Windows in taskbar" options at the same time. I'm
funning Office Small business 2000 with Powerpoint 2003.




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: http://www.excelforum.com/member.php...o&userid=24718
View this thread: http://www.excelforum.com/showthread...hreadid=526775