Forum Discussion
Microsoft Excel 2013
At my work I have a shared Excel sheet between a few colleagues. On their computers all the sheets appear, on mine, however, there are one or two sheets that have completely disappeared. I have checked to see if I have the display all sheets enabled, which it is. I'm not sure why my computer is the only one affected, I did inherit it from a former colleague and am not sure what settings they may have put on the computer itself.
This is very frustrating as there is information on those sheets that I can't access when a client calls and have to constantly put them on hold to ask my colleagues for information regarding this excel.
8 Replies
- Another option would be to right click on one of the worksheet tabs then click on unhide. If any of the tabs (worksheets) are hidden, then you can unhide them and see what you need.
if some sheets are hided they are hided for all people who share workbook on the server. If one person unhides, he unhides for all. If only, as it was said before, workbook structure is not protected by macro for certain person or pc account
- Agreed, the hidden sheet is the only other thing I could think of, otherwise its a macro. The only problem there is that Kim says there is no macro. I look forward to hearing what the solution ends up being!
Hello Kim
Probably a macro that hides sheets depending on user name or machine name.
Is there a way for me to fix that? I'm not sure why my predecessor would have set one up as they would have needed this sheet too.
Press ALT-F11 and check wether there is a code in the various modules that hides sheets.
Or that could be as simple as they are under scrolling bar and not visible. To check stay on any sheet and navigate by Ctrl+PgDn (or Ctrl+PgUp) repeatedly before you return to starting sheet. Check if not visible sheets appears in between.
Tried ctrl+pgdown and ctrl+pgup. The sheets still do nto appear for me.
