Worksheet Disappears

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

Guest

I've received a report from one of our users that a worksheet within an Excel Spreadsheet disappeared. They created the additional worksheet and saved the document. Later they pulled up the document and the worksheet was no longer there. Two employees were at the computer at the time and both insist that they saved the document at it's existing location. I've looked at the spreadsheet and there are only a few worksheets at the bottom. Has anyone ever heard of this happening? Is it possible that the tab for one worksheet is hidden behind another tab? Any help would be appreciated.
 
Stacy, check the Sheet command on the Format menu and see if Unhide is not
grayed out. It's possible the worksheet was inadvertently hidden (if not
inadvertently deleted).

--
DDM
"DDM's Microsoft Office Tips and Tricks"
Visit us at www.ddmcomputing.com


SNewsome said:
I've received a report from one of our users that a worksheet within an
Excel Spreadsheet disappeared. They created the additional worksheet and
saved the document. Later they pulled up the document and the worksheet was
no longer there. Two employees were at the computer at the time and both
insist that they saved the document at it's existing location. I've looked
at the spreadsheet and there are only a few worksheets at the bottom. Has
anyone ever heard of this happening? Is it possible that the tab for one
worksheet is hidden behind another tab? Any help would be appreciated.
 
Have you tried looking under Format-->Sheet-->Unhide or
Window-->Unhide? Sometimes a worksheet will
mysteriously 'hide' and you need to unhide it to get it
back.

Dale
-----Original Message-----
I've received a report from one of our users that a
worksheet within an Excel Spreadsheet disappeared. They
created the additional worksheet and saved the document.
Later they pulled up the document and the worksheet was no
longer there. Two employees were at the computer at the
time and both insist that they saved the document at it's
existing location. I've looked at the spreadsheet and
there are only a few worksheets at the bottom. Has anyone
ever heard of this happening? Is it possible that the tab
for one worksheet is hidden behind another tab? Any help
would be appreciated.
 
Try:

<Format> <Sheet>

And see if "Unhide" IS available (not grayed out).
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I've received a report from one of our users that a worksheet within an
Excel Spreadsheet disappeared. They created the additional worksheet and
saved the document. Later they pulled up the document and the worksheet was
no longer there. Two employees were at the computer at the time and both
insist that they saved the document at it's existing location. I've looked
at the spreadsheet and there are only a few worksheets at the bottom. Has
anyone ever heard of this happening? Is it possible that the tab for one
worksheet is hidden behind another tab? Any help would be appreciated.
 
Back
Top