Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
giantwolf
 
Posts: n/a
Default Problem opening Excel file


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

  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default Problem opening Excel file

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


  #3   Report Post  
Posted to microsoft.public.excel.misc
giantwolf
 
Posts: n/a
Default Problem opening Excel file


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

  #4   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default Problem opening Excel file

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



  #5   Report Post  
Posted to microsoft.public.excel.misc
Ramona
 
Posts: n/a
Default Problem opening Excel file

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






  #6   Report Post  
Posted to microsoft.public.excel.misc
giantwolf
 
Posts: n/a
Default Problem opening Excel file


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

  #7   Report Post  
Posted to microsoft.public.excel.misc
giantwolf
 
Posts: n/a
Default Problem opening Excel file


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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 12:46 PM
Opening Excel and chosen file from Explorer The Grape Hunter Setting up and Configuration of Excel 0 February 26th 06 03:52 AM
Opening Excel File Mohd Anis Excel Discussion (Misc queries) 3 September 26th 05 09:10 AM
Excel getting Error - file format is not valid WHEN OPENING babu Excel Discussion (Misc queries) 1 August 24th 05 10:09 PM
opening file problem please help Steve Goodrich Excel Discussion (Misc queries) 2 March 1st 05 11:40 PM


All times are GMT +1. The time now is 05:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"