Excel 2003 problem opening existing spreadsheet

[dick314]

I have a spreadsheet that I can't open. When I double-click on it
Excel 2003 starts up but the spreadsheet doesn't open. It's just as
if the Excel application was started without any file open. The .xls
file size indicates my data is still there. My last update to it was
to add two worksheets - the 16th and 17th, I believe. One of them
contains a plot. The volume of data in the SS is not large. I have
no problem opening other .xls files, just this one. Any help would be
greatly appreciated.

Dick

 

[Bob Flanagan]

Could by chance you have hidden the workbook window and then saved it? If
so, it will open but be hidden. It sounds like you did as you didn't
mention that Excel is crashing. Click on Window, Unhide and see if the
workbook is there.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

 

[dick314]

Could by chance you have hidden the workbook window and then saved it? If
so, it will open but be hidden. It sounds like you did as you didn't
mention that Excel is crashing. Click on Window, Unhide and see if the
workbook is there.

Bob Flanagan
Macro Systemshttp://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

Bob,
Thanks so much! That's exactly what my problem was. The workbook was
inadvertantly hidden and dumb me didn't know about hidden workbooks.
I'm back in business and happy!
Dick

 

[Guest]

I am experiencing something very similar. No crashs or error messages of any
kind. Just yesterday and booted up the PC, double-clicked on my excel file
icon on my desktop and excel openned by the workbook did not. However, if I
click on "open" from the file menu in excel I can open the workbook and
everything is normal.

Is there a way to get the workbook to open again in excel when I click on my
desktop excel icon? This 2 step process is painful.

 

[Dave Peterson]

Sometimes one of these works when you're having trouble with double clicking on
the file in windows explorer:

Tools|Options|General|Ignore other applications (uncheck it)

--- or ---

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.

Maybe one of these will work for you.