Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default XL file opens but does not display

When I "open" some XL files, recently edited OK, no file appears on screen.
Screen remains grey, toolbars are mostly greyed out. Backup file loads OK. It
appears workbook is hidden, but I did not call for that to happen when file
was last open. Why should this happen? How to stop in future?
--
BrianE
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 663
Default XL file opens but does not display

Hi,

My assumption: Just check whether you have a minimzed the workbook. Look at
the bottom left corner. If the workbook is minimized, the all command in the
menu would appear grey.

Challa Prabhu

"BrianE" wrote:

When I "open" some XL files, recently edited OK, no file appears on screen.
Screen remains grey, toolbars are mostly greyed out. Backup file loads OK. It
appears workbook is hidden, but I did not call for that to happen when file
was last open. Why should this happen? How to stop in future?
--
BrianE

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default XL file opens but does not display

Can you tell if the workbook actually loaded? Maybe using file|print preview???

If you can see the data to be printed, then maybe the worksheet window is just
out of view of the application window.

Try: Window|Arrange|tiled and resize the way you like it.

If excel didn't open the file...

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.

BrianE wrote:

When I "open" some XL files, recently edited OK, no file appears on screen.
Screen remains grey, toolbars are mostly greyed out. Backup file loads OK. It
appears workbook is hidden, but I did not call for that to happen when file
was last open. Why should this happen? How to stop in future?
--
BrianE


--

Dave Peterson
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default XL file opens but does not display

Thanks Guys for your comments. They did not quite meet the point in question.
I discovered that the whole workbook was hidden, and could be restored to
view by the Unhide command. As I had last closed/saved the file when in full
view I do not understand why it should reload as hidden.
--
BrianE


"Dave Peterson" wrote:

Can you tell if the workbook actually loaded? Maybe using file|print preview???

If you can see the data to be printed, then maybe the worksheet window is just
out of view of the application window.

Try: Window|Arrange|tiled and resize the way you like it.

If excel didn't open the file...

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.

BrianE wrote:

When I "open" some XL files, recently edited OK, no file appears on screen.
Screen remains grey, toolbars are mostly greyed out. Backup file loads OK. It
appears workbook is hidden, but I did not call for that to happen when file
was last open. Why should this happen? How to stop in future?
--
BrianE


--

Dave Peterson

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
Opening file in Excel 2003 opens multipule instances of same file Ed_B Excel Discussion (Misc queries) 1 June 21st 07 07:10 PM
how do I display a automatically message when excel opens? Prakash Excel Discussion (Misc queries) 2 March 23rd 06 01:03 PM
Double-clicking .xls file opens Excel but doesn't open the file DG Excel Discussion (Misc queries) 4 January 6th 06 02:20 AM
opening an excel file opens a duplicate file of the same file skm Excel Discussion (Misc queries) 1 December 7th 05 05:52 PM
clicking .XLS file opens Excel 2003 but doesn't find the file Arrow Computer Excel Discussion (Misc queries) 2 August 10th 05 03:51 AM


All times are GMT +1. The time now is 01:28 PM.

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

About Us

"It's about Microsoft Excel"