Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
My sheet tabs disappeared with entered data. Can it be restored?
I am using MSOffice 2003, Excel, for couple months. Entered lots of data,
using sheet tabs for coordinated data. However, suddenly, when opened my worksheets, the sheet tabs disappeared. Therefore my data is not accessible. Did I lose it, or can it be resotred? If so, how? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
My sheet tabs disappeared with entered data. Can it be restored?
If you hit ALT F11 can you see all the sheet names that should in the
project explorer on the left of you screen? Irene V in NJ wrote: I am using MSOffice 2003, Excel, for couple months. Entered lots of data, using sheet tabs for coordinated data. However, suddenly, when opened my worksheets, the sheet tabs disappeared. Therefore my data is not accessible. Did I lose it, or can it be resotred? If so, how? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
My sheet tabs disappeared with entered data. Can it be restored?
You say "sheet tabs disappeared"
Do you see anything when you open the workbook? One worksheet or nothing? If you go to ToolsOptionsView is "sheet tabs" unchecked? If so, check it. Gord Dibben MS Excel MVP On Mon, 11 Sep 2006 13:21:02 -0700, Irene V in NJ <Irene V in wrote: I am using MSOffice 2003, Excel, for couple months. Entered lots of data, using sheet tabs for coordinated data. However, suddenly, when opened my worksheets, the sheet tabs disappeared. Therefore my data is not accessible. Did I lose it, or can it be resotred? If so, how? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
My sheet tabs disappeared with entered data. Can it be restored?
And if the tabs are still there, but just off the screen:
Window|arrange|Tiled and resize the way you want. And you can use ctrl-pgup and ctrl-pgdn to cycle through the visible worksheets (even if the tabs aren't visible!). Irene V in NJ wrote: I am using MSOffice 2003, Excel, for couple months. Entered lots of data, using sheet tabs for coordinated data. However, suddenly, when opened my worksheets, the sheet tabs disappeared. Therefore my data is not accessible. Did I lose it, or can it be resotred? If so, how? -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
My sheet tabs disappeared with entered data. Can it be restore
Thanks for answering. I should have explained more. in Tools - Options =
General = Sheet tabs is checked. Under Format - sheet - Unhide is grayed out, so I cannot access. When I open workbook - only one workbook shows up with no sheet tabs, where I have related data, I tried to go page up or down, but sheet tabs are not there . I wonder if Excel 2003 converted to older version where sheet tabs were not existant? "Gord Dibben" wrote: You say "sheet tabs disappeared" Do you see anything when you open the workbook? One worksheet or nothing? If you go to ToolsOptionsView is "sheet tabs" unchecked? If so, check it. Gord Dibben MS Excel MVP On Mon, 11 Sep 2006 13:21:02 -0700, Irene V in NJ <Irene V in wrote: I am using MSOffice 2003, Excel, for couple months. Entered lots of data, using sheet tabs for coordinated data. However, suddenly, when opened my worksheets, the sheet tabs disappeared. Therefore my data is not accessible. Did I lose it, or can it be resotred? If so, how? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
My sheet tabs disappeared with entered data. Can it be restore
FormatSheetUnhide is most likely grayed out because you have no sheets hidden
or you have the workbook protected under ToolsProtectionProtect Workbook. When you open the workbook only one worksheet shows up and has no sheet tab...correct? ToolsOptionsVIEW has Sheet Tabs checked.......correct? Try CTRL + PageUp and CTRL + PageDown. Any different sheets show up? The last version without multi-sheets was Excel 4.0 so I doubt you converted that far back. If the data is not sensitive you could email the workbook to my personal address, not to the group. Change the DOT and AT to unmunge. Gord Dibben MS Excel MVP On Mon, 11 Sep 2006 17:52:01 -0700, Irene V in NJ wrote: Thanks for answering. I should have explained more. in Tools - Options = General = Sheet tabs is checked. Under Format - sheet - Unhide is grayed out, so I cannot access. When I open workbook - only one workbook shows up with no sheet tabs, where I have related data, I tried to go page up or down, but sheet tabs are not there . I wonder if Excel 2003 converted to older version where sheet tabs were not existant? "Gord Dibben" wrote: You say "sheet tabs disappeared" Do you see anything when you open the workbook? One worksheet or nothing? If you go to ToolsOptionsView is "sheet tabs" unchecked? If so, check it. Gord Dibben MS Excel MVP On Mon, 11 Sep 2006 13:21:02 -0700, Irene V in NJ <Irene V in wrote: I am using MSOffice 2003, Excel, for couple months. Entered lots of data, using sheet tabs for coordinated data. However, suddenly, when opened my worksheets, the sheet tabs disappeared. Therefore my data is not accessible. Did I lose it, or can it be resotred? If so, how? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
My sheet tabs disappeared with entered data. Can it be restored?
It's a long shot, but it is possible to cover the sheet tabs by dragging
the edge of the horizontal scroll bar over the tabs. Could this have accidentally happened? Len Irene V in NJ wrote: I am using MSOffice 2003, Excel, for couple months. Entered lots of data, using sheet tabs for coordinated data. However, suddenly, when opened my worksheets, the sheet tabs disappeared. Therefore my data is not accessible. Did I lose it, or can it be resotred? If so, how? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
My sheet tabs disappeared with entered data. Can it be restore
Thank you. Wonders will never cease. Just a suggestion to go to task bar,
did it. I clicked in the empty space, and all sheet tabs appeared. Would like to know more about it, but meanwhile - it's OK. Irene V in NJ "Gord Dibben" wrote: FormatSheetUnhide is most likely grayed out because you have no sheets hidden or you have the workbook protected under ToolsProtectionProtect Workbook. When you open the workbook only one worksheet shows up and has no sheet tab...correct? ToolsOptionsVIEW has Sheet Tabs checked.......correct? Try CTRL + PageUp and CTRL + PageDown. Any different sheets show up? The last version without multi-sheets was Excel 4.0 so I doubt you converted that far back. If the data is not sensitive you could email the workbook to my personal address, not to the group. Change the DOT and AT to unmunge. Gord Dibben MS Excel MVP On Mon, 11 Sep 2006 17:52:01 -0700, Irene V in NJ wrote: Thanks for answering. I should have explained more. in Tools - Options = General = Sheet tabs is checked. Under Format - sheet - Unhide is grayed out, so I cannot access. When I open workbook - only one workbook shows up with no sheet tabs, where I have related data, I tried to go page up or down, but sheet tabs are not there . I wonder if Excel 2003 converted to older version where sheet tabs were not existant? "Gord Dibben" wrote: You say "sheet tabs disappeared" Do you see anything when you open the workbook? One worksheet or nothing? If you go to ToolsOptionsView is "sheet tabs" unchecked? If so, check it. Gord Dibben MS Excel MVP On Mon, 11 Sep 2006 13:21:02 -0700, Irene V in NJ <Irene V in wrote: I am using MSOffice 2003, Excel, for couple months. Entered lots of data, using sheet tabs for coordinated data. However, suddenly, when opened my worksheets, the sheet tabs disappeared. Therefore my data is not accessible. Did I lose it, or can it be resotred? If so, how? |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
My sheet tabs disappeared with entered data. Can it be restored?
Good point Len
Gord On Mon, 11 Sep 2006 22:11:39 -0600, LenB wrote: It's a long shot, but it is possible to cover the sheet tabs by dragging the edge of the horizontal scroll bar over the tabs. Could this have accidentally happened? Len Irene V in NJ wrote: I am using MSOffice 2003, Excel, for couple months. Entered lots of data, using sheet tabs for coordinated data. However, suddenly, when opened my worksheets, the sheet tabs disappeared. Therefore my data is not accessible. Did I lose it, or can it be resotred? If so, how? Gord Dibben MS Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro | Excel Discussion (Misc queries) | |||
automatically show data entered on another sheet within the workbo | Excel Worksheet Functions | |||
Importing Data | Excel Worksheet Functions | |||
data from one sheet to several in sequential order! | New Users to Excel | |||
Merger Two Data Sheet | Excel Discussion (Misc queries) |