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.