Only able to view worksheet in full screen view or print preview

Rondi

New Member
Joined
Jun 15, 2005
Messages
45
I'm trying to open a 2003 Excel spreadsheet from Excel 2007. The file opens, but the spreadsheet is grayed out. There's no tabs, no rows or columns, only the "named cell references" are available. If I view spreadsheet in full screen view or print preivew, I can see it. What is wrong?
 

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Mister H

Well-known Member
Joined
Mar 6, 2002
Messages
1,507
Hi Rondi:

Not sure if you got it figured out but I am thinking that maybe some options have been removed. You may very well have checked this out already but just in case:

Open File
Select Tools/Options...
Click on the View TAB and make sure that "Sheet tabs" and "Row & column headers" are both checked off. HOPEFULLY that gives you a start...

As for it being grayed out I am not really sure. Maybe there is another option under view or maybe the sheet has been Protected. To remove Protection select Tools\Protection\Unprotect sheet

Good Luck,
Mark :)
 

Rondi

New Member
Joined
Jun 15, 2005
Messages
45
I'm working in Excel 2007 so I'm having a difficult time finding my old menu options so I'm not following your suggestions. I did verify that my "Sheet Options" do have the "View" "Gridlines" and "Headings" have been checked. My screen looks like I have not opened a worksheet, it appears blank, except for the "named reference" which refers to cells in my worksheet. When I view in "full Screen," I can see my worksheet. But I can't work in full screen and I'm not the only user. This same problem happens on my co-workers computer as well. Another oddity, if I choose "New Window" from the "window" toolbar, it opens the worksheet in the new window.

I was able to verify that my worksheet is not hidden nor is the worksheet protected. I just can't see it (doesn't that sound funny ;)
 

Mister H

Well-known Member
Joined
Mar 6, 2002
Messages
1,507
Hi Rondi:

SORRY for the confusion.

That does sound weird...

Maybe the sheet is just off screen? :confused:

TRY:

Window\Arrange\Tiled

Or possibly

Window\Arrange Icons

If that doesn't get your sheet back I am at a loss. If you want I can provide my email address as once I see it it may be a quick fix, but if it is a confidential sheet you may not want to go that route.

Good Luck Rondi.
Take Care,
Mark :)
 

Rondi

New Member
Joined
Jun 15, 2005
Messages
45
Yep, the Window/Arrange All/Tiled worked! Thanks for the quick fix.

I read on another message board where this was a problem when someone saved it with different display settings and especially on laptops. I have a laptop plus dual 21" display monitors. It's entirely possible that when I saved it last, I had Excel expanded across both monitors before I saved it. I made sure this time that I was only viewing on one monitor and re-saved. It seems to be working fine now.

Thanks again!
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,056
Messages
5,509,061
Members
408,701
Latest member
daz457

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top