first query here. I'm being driven crazy by not being able to open one file from thousands. I'm using MacOS Catalina 10.15.6 & Excel for Mac 16.4.
When upgrading from Office 2011 every time I opened a .xls file I saved as .xlsx. Over the past three months I've saved thousands of files like this. Today, one refused to open. Dialogue boxes when attempting to open queried validity or extension name. The file was created in Excel six weeks ago and has been opened since with no problems. I opened similar, created at same time, both before and after attempting to open this one with no problem.
Then there's a message saying it may be read-only or encrypted. It's neither. I have permission to read and write (it's my own fil after all) and it hasn't been encrypted
I make a copy to see if that helps. Dialogue box says again it may be corrupted or read only and then laughably it might be on a server that isn't responding.
I've done everything I can think of. Zipped the file and tried to open unzipped. Changed file extension to .xls, changed application to open to first Numbers then OpenOffice. All without success.
Crazily, Excel's 'quick look' function works and I can see the file with all tabs and all data intact but can't do anything else from this option like a save as or export.
The get info box says the file was most recently opened today when of course it didn't open. But Excel's recently opened option doesn't show it at all.
One file. From literally thousands.
I've been using Excel since Office 2001 and I've never come across a version as bad as this current one. There are other issues but they're trifling compared to not being able to open an important file.
I've tried every help option possible but the only advice I can find is either something I've already tried or related to previous versions of Excel and aren't applicable here.
Any advice greatly appreciated.
Thanks in advance