Sheet tabs disappear on SOME sheets only

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Some multi-sheet workbooks created on this machine no longer show the page
tabs.

A new multi-sheet workbook was created and saved. It works fine.

The workbooks that were working and no longer work, appear fine on other
machines in both Excel 2003 and 200. Re-saving and returning them to the
problem machine does not solve the problem.

They were saved in Excel 2000. Repairing the installation did not solve the
problem. Upgrading to Excel 2003 did not solve the problem.
 
Don J. CMC said:
Some multi-sheet workbooks created on this machine no longer show the page
tabs.

A new multi-sheet workbook was created and saved. It works fine.

The workbooks that were working and no longer work, appear fine on other
machines in both Excel 2003 and 2007. Re-saving and returning them to the
problem machine does not solve the problem.

They were saved in Excel 2000. Repairing the installation did not solve the
problem. Upgrading to Excel 2003 did not solve the problem.
Click to expand...
 
Did you try Tools -> Options and there on Display tab check sheet tabs? (this
is fine in Excel 2002)
 
I did try that. It works only for new sheets on that machine. The old
sheets have no tabs on that machine even though they work fine on other
machines.
 
When you say have no tabs, does it mean you cannot switch display tabs on/off
through Tools -> Options menu? This one works separately for each worbook.
So, try to display sheet tabs through Tools -> Options once your sick file is
active. You said you did, but maybe we do not undertstand each other. Hope
this help, cannot help more.
 
I did try that. It switches the tabs on and off on new workbooks, but does
nothing to the old ones.

Thanks.
 
Back
Top