Cannot see worksheet tabs in Excel 2010

Anonymous

Hi,

I am using Windows 7 and Microsoft Office Professional Plus 2010 (Beta). I am unable to view worksheet tabs in a particular Excel document. From my research on the internet, I have discovered that it is a resolution issue - the person creating the document used a resolution higher than my maximum resolution. I have tried all the Microsoft suggestions - arranging windows, ensuring 'show tabs' are selected etc. Has anyone managed to overcome this? Or does anyone know of a shortcut to unhook a worksheet from it's container so it can be resized independently?

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous

Hi BB,

**"Is the workbook protected by any chance? If yes then unprotect the workbook to see if the issue is resolved"**Yes, this workbook is protected, and unprotecting it is not an option. I would like a solution that does not involve saving a copy of the workbook.

**"Does this happen with all workbooks or only some of them"**Details on how to reproduce this bug later

**"What happens if you start excel in safe mode and then open these files?"**Not feasible as a permanent solution

**"Does this workbook have macros?"**No

**"Are you able to see the sheet tabs when you create a blank / new workbook?"**Yes

**"Check if the following..."**Already done prior to posting this article.

**How to reproduce this bug:**This bug is basically a resolution error:

Select the maximum resolution on your PC (e.g. 1280 x 1024)
Open Excel and create a workbook with at least 2 worksheets
Save this worksheet and close excel
Select the minimum resolution on your PC (e.g. 800 x 600)
Open the saved Excel document you created in step 2

NB: The greater the resolution difference, the harder it is to solve this error. Some times you can solve this error with the 'Arrange Windows' button if the resolution difference isn't too large.

If one had a shortcut to unhook the worksheet from the main Excel window, it would be easier to solve.

P.S.: Microsoft Answer Quote absolutely SUCKS

0 comments

41 additional answers

Anonymous

2010-03-18T09:02:20+00:00
Is the workbook protected by any chance? If yes then unprotect the workbook to see if the issue is resolved

Does this happen with all workbooks or only some of them?

what happens if you start excel in safe mode and then open these files?

Does these workbook have macros?

Are you able to see the sheet tabs when you create a blank / new workbook ?

Check if the following settings in excel options:
1. Click on file > Options > Advanced
2. Display options for this workbook > Display options for this workbook > Check the option - Show Sheet Tabs
BLACK BARRON

P.S : Please post back with the status of the issue. If this post was helpful to you, please vote for my post If this post has helped you resolve your issue, please mark my post as answered.
Was this answer helpful?

3 people found this answer helpful.

0 comments No comments
Anonymous

2010-03-18T08:32:43+00:00

Pat, this solution is not feasible.
Was this answer helpful?

0 comments No comments
Anonymous

2010-03-17T08:52:37+00:00

You might like to try CTRL A to select all

Ctrl C copy

closed down the worksheet

open a new workbook and

CTRL V paste into the new work book which I am hoping displays as you would like it to.

Pat PS If you found this useful please vote. Thank you:¬)
Was this answer helpful?

0 comments No comments
Anonymous

2010-03-17T08:05:04+00:00

Hi Khan,

Open the excel spreadsheet click on View > New window resave the Excel spreadsheet.

The 'New Window' button is disabled.
Was this answer helpful?

1 person found this answer helpful.

0 comments No comments