Problem opening Excel file

G

giantwolf

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
 
G

giantwolf

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.
 
C

CLR

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
 
R

Ramona

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 said:
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
Click to expand...
 
G

giantwolf

CLR said:
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" <[email protected]>
wrote
in message
Click to expand...

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

giantwolf

Ramona said:
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.
Click to expand...


Neither of these are checked and it doesn't fix it by checking them and
then unchecking them. Thanks for the suggestion.
 
Top