Forum Discussion

Raj0212's avatar
Raj0212
Copper Contributor
Jun 30, 2022
Solved

One specific Excel file is entirely grayed out when I open it.

Hi,

I'm facing a strange issue. I was working on one of my Excel files (password protected) and suddenly I possibly pressed some button(s) by mistake (not sure), causing the file to vanish from the screen. There were a couple of other open files still working fine though.

When I open that file again giving its password, then it shows that everything is grayed out (pasted below). Even the title bar is not showing the same file name. Then I tried opening other files, and they opened just fine and worked as usual. 

Can anyone help urgently? It has some critical data that I need.

Thanks.

 

 

5 Replies

    • Robertlee417's avatar
      Robertlee417
      Copper Contributor

      Patrick2788 
      This is not working for me. I have a user that has a file like this. Lets call it File A. Any other file,(File B, C, D) shows up. I can open File A and see the data.  I looked at the Unhide and it is not hidden.  I have tried the Ctrl + 0 and it does nothing.

    • Raj0212's avatar
      Raj0212
      Copper Contributor
      Thanks Patrick. It worked (sigh of relief). In fact, I noticed that this "Unhide" button was the only clickable and rest all grayed out 🙂
      Thanks again!
      • Patrick2788's avatar
        Patrick2788
        Silver Contributor
        Glad it worked. Typically the Hide workbook feature is used with the Personal Macro workbook to give one access to macros but keep the book hidden.

Resources