Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 27th 08, 08:09 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2008
Posts: 1
Default When I open a saved worksheet, it opens with a gray background

Office 2003: I have a user with a saved worksheet that is used on a
bi-monthly basis. When she tried to open it on her computer it opened in a
blank gray status with no worksheets showing. I tried to open the document
on another machine while that document was open on her's and I got the
message that it was open and locked for editing. The size of the .xls shows
that it is not a blank document, but you cannot see the spreadsheet or any
others (no tabs at the bottom). Oddly enough, when I tried to access this
..xls from a Office 2007 computer, the spreadsheet opened with no problems.
This .xls had never been opened with Office 2007 before as it is only
installed on 2 test computers in my office. Also, this problem is not
consistent with all of her .xls files. Only the one. Is this a corrupt
document that needs to be restored from backup? Or is it something else?

  #2   Report Post  
Old February 27th 08, 08:48 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,907
Default When I open a saved worksheet, it opens with a gray background

Are you sure that the file was opened?

If you go to FilePrintPreview, can you see data?

If yes, then maybe the sheet window is just off the visible screen.

Try: WindowArrangeTiled (and resize the way you like).


Gord Dibben MS Excel MVP

On Wed, 27 Feb 2008 12:09:05 -0800, MichelleJ
wrote:

Office 2003: I have a user with a saved worksheet that is used on a
bi-monthly basis. When she tried to open it on her computer it opened in a
blank gray status with no worksheets showing. I tried to open the document
on another machine while that document was open on her's and I got the
message that it was open and locked for editing. The size of the .xls shows
that it is not a blank document, but you cannot see the spreadsheet or any
others (no tabs at the bottom). Oddly enough, when I tried to access this
.xls from a Office 2007 computer, the spreadsheet opened with no problems.
This .xls had never been opened with Office 2007 before as it is only
installed on 2 test computers in my office. Also, this problem is not
consistent with all of her .xls files. Only the one. Is this a corrupt
document that needs to be restored from backup? Or is it something else?


  #3   Report Post  
Old March 7th 08, 01:32 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2008
Posts: 8
Default When I open a saved worksheet, it opens with a gray background

On Feb 28, 4:48*am, Gord Dibben <gorddibbATshawDOTca wrote:
Are you sure that the file was opened?

If you go to FilePrintPreview, can you see data?

If yes, then maybe the sheet window is just off the visible screen.

Try: * WindowArrangeTiled (and resize the way you like).

Gord Dibben *MS Excel MVP

On Wed, 27 Feb 2008 12:09:05 -0800, MichelleJ



wrote:
Office 2003: *I have a user with a saved worksheet that is used on a
bi-monthly basis. *When she tried to open it on her computer it opened in a
blank gray status with no worksheets showing. *I tried to open the document
on another machine while that document was open on her's and I got the
message that it was open and locked for editing. *The size of the .xlsshows
that it is not a blank document, but you cannot see the spreadsheet or any
others (no tabs at the bottom). *Oddly enough, when I tried to access this
.xlsfrom a Office 2007 computer, the spreadsheet opened with no problems. *
This .xlshad never been opened with Office 2007 before as it is only
installed on 2 test computers in my office. *Also, this problem is not
consistent with all of her .xlsfiles. *Only the one. *Is this acorrupt
document that needs to be restored from backup? *Or is it something else?- Hide quoted text -


- Show quoted text -


Maybe your xls file is corrupt. You may try a popular Excel file
recovery tool called Advanced Excel Repair to repair your Excel file.
It is a powerful tool to repair corrupt or damaged Excel files.

Detailed information about Advanced Excel Repair can be found at
http://www.datanumen.com/aer/

And you can also download a free demo version at http://www.datanumen.com/aer/aer.exe

Alan


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 does not open, just opens a the grey background Steve New Users to Excel 2 May 17th 06 03:00 AM
saved worksheet opens in new with macro error report margaret Excel Worksheet Functions 0 April 19th 06 11:56 AM
Graph format? i.e. no gray background Paul Burton Charts and Charting in Excel 1 February 6th 06 11:54 PM
I open one excel worksheet, PERSONAL.XLS also opens, why? harry Excel Discussion (Misc queries) 1 December 22nd 05 06:02 PM
When I open up excel a worksheet that has been inputed opens up w. EL GUAPO Excel Discussion (Misc queries) 3 April 17th 05 08:52 PM


All times are GMT +1. The time now is 09:05 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017