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 am having the same issue. 5th File corrupted today and microsoft support is unable to help. Frankly I am at my wits end. It is appalling that no on at Microsoft or Apple can pull this together and solve it. I’ve used Excel for c30 years and Apple for as long as I can remember.
That’s just it. I was using OneDrive. Then they added the 365 app and that’s when things went sideways. I mention iCloud since I believe it’s all related somehow, but I’m not a tech, and no one from OneDrive, MS, or Apple seemingly has had no interest in fixing this. Every day I do the same thing open a file, close a file, reopen. Never change name, location, delete. Yet, they got deleted, and I never saw them in recycle till I got the late night email from an Escalation Manager from MS (only contact I ever got) saying you have 2 hours left to move them back, or they’re gone forever. That’s the only time I saw them in Recycle, that was May 12, 29 days + ~20hours after they initially disappeared.
I have been successfully using OneDrive on my PC, iPhone and iPad Pro while editing the same spreadsheet. It doesn't appear the O365/iCloud issue will be resolved in a timely fashion so I recommend using OneDrive.
I still have not heard anything from OneDrive, MS, Apple, no one. iCloud seems to be the culprit in how 365 products live on iOS platforms. Only thing I can do is mitigate risk and email files to myself, send to Numbers, keep copies offline. I will need to renew my 365 subscription at some point, decisions will need to be made. This is. Sorry state of affairs.
Is there a structural solution available for this from Microsoft?
Unfortunately none of the suggestion in this thread work for me.
Pretty pathetic issue to have which renders 365 useless on iCloud.