Crashed/Recovered excel ... enable macros greys out everything!

[spacely]

Desperate:

My excel crashed. I rebooted, and downloaded a backup copy of it. Now when i open it, it says:

"SECURITY WARNING some active content has been disabled. Click for more details."

I instead Enable Content, and when it does so, most features are grayed out, including saving it and even closing it! It's completely useless like that. That copy was always OK, so I don't know if excel on my actual computer is hosed, or if that file is forever marked as a "problem" that needs to be "isolated". The file is really OK.

How do I teach excel it's really OK?

excel v2016

 

[Michael M]

If it has macros, disable them before opening.
Try renaming the file in Explorer
Have you tried the file on a different PC
Did you reboot Excel or the whole PC.....reboot the whole PC if you didn't

 

[spacely]

So, I copied the excel to a different computer, opened it, activated macros... it was OK... saved under new name, moved back to old computer...opened/closed OK... renamed it... opened/closed OK.

That seemed to wake up the situation

I was about to do this: https://stackoverflow.com/questions...usted-document-with-macros-or-enabling-macros

 

[Michael M]

Ok, sounds good....