Excel Worksheet Disappeared But Still Open
Open excel, and click file > info > manage workbook.
Excel worksheet disappeared but still open. You can then choose the one you want to see and click ok, and it will re appear. Open the excel file in question on ms excel. When i search for it in windows explorer it has been renamed with file:/// at the front and appears with a globe icon at the front as if it is an internet link.
If this issue occurs in excel, and the excel worksheet that you are working on contains shared toolbars or was created in a different version of excel, it may be necessary to rename the file that contains the shared toolbar settings. At least one worksheet must be visible at all times. Today i was working on an excel sheet in office 365 on windows 10.
The move command is gray' and does not work. So to get the missing sheet tab back you must use the unhide worksheet of excel. They aren't hidden or in the recycle bin, and cortana couldn't find either of them.
As with hiding worksheets, excel has no keyboard shortcut for unhiding a sheet, but you can still use the ribbon. On wednesday, i opened excel and the spreadsheets had disappeared. I can't get from one page of a workbook to another.
They are still logged into the computer (a shared computer) but that user profile is locked, and another user logs in. Both are still listed when i open excel under recent workbooks, but when i click on them, it says not found. There are times when we try to open an excel file but then it refuses to open.
When i open a new or existing excel file, the sheet tabs at the bottom may or may not show up. In order to see it again, click the unhide option in the view tab and it will give you a list of hidden workbooks. This is in offfice 2003.