This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi,
I'm hoping someone can help me with 2 xlsx files that have been corrupted.
I use iCloud to store my documents, I finished working on the 2 files in question on my MacBook in the morning and then later in the day successfully viewed them (not modified) on my iPhone using the Office 365 app.
When I came to open the files again, they are unable to be opened on any device using either numbers or excel. I have tried on my iPhone, MacBook and a Windows 11 PC. The error message is:
"Excel cannot open the file 'ABCDEF.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file."
I have tried changing the file extension to xls. I've tried to open and repair the files using Excel on Windows however that hasn't worked either. I've used a couple of trial versions of recovery software and the preview shows the first sheet is there but the remaining sheets aren't which are vital to the spreadsheet.
Does anyone have any ideas or experience of this issue? I've noticed the timestamp of last saved has changed to the date and time I opened them on my phone. I'm not sure why Office365 resaved these files without me making changes or asking me.
Thanks
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
I found a way after it happened to me! I have an Excel that I save on iCloud and I opened it on my iPhone and after I got this message.
On your Mac, right click on the file with the message and open it with numbers. It will ask you to see old versions to restore, choose an older version.
Hope it helps you !
Having the same issue. Pls fix
I too ran into this exact issue editing an Excel spreadsheet on my iPad/iPhone. I normally edit the spreadsheet on my MacBook. What I'm so displeased about with iCloud is the lack of restoring a file. Had my spreadsheet been on SharePoint/OneDrive, I could have chosen to restore to a previous version. Now I'm making a monthly backup of my file and avoiding opening any Excel spreadsheets on iOS.
Jonathan OO how where you able to open the file in numbers? My "numbers" iOS App states " table could not be imported" when trying to open from iCloud. Unfurtonately I do have only an iPhone but no Mac.
Same on my side. Lost very important data in one xlsx file after modifying one cell and save it back to iCloud from iOS Excel App. Used iCloud as backup. 3 Months work gone (this was the time of the last "manual" backup". FIX IT MS!