Office 365 iOS App Corrupted Excel File

Anonymous
2023-03-18T18:37:50+00:00

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

Microsoft 365 and Office | Excel | For home | iOS

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.

0 comments No comments

48 answers

Sort by: Oldest
  1. Anonymous
    2023-10-05T00:29:37+00:00

    It seems as though either Apple or MS or 365 has thrown us users to the wolves, neither seems to want to fix this issue. Every day I use my files (on iPad Pro) and every day I half expect an issue. I don’t even have aWindows computer any longer. It should not be this way. Though it’s always wise to keep backups, why should I have to send files to Numbers, or email some point-in-time version to myself because it might disappear. Again. My 365 subscription will need to renew in a few months and then I’ll ask myself next steps.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2023-10-30T12:10:04+00:00

    I had the same issue. corrupted excel file 66kb.

    downloaded Numbers, tried to open the file.

    gives same error message, corrupt file but then gives message about changes not synced and gets a few old versions. lets you choose which version to keep. timestamp only goes dd-mm--yy hh-mm and I had only 3 versions to restore.

    all incomplete, some very old, some workbooks lost. but at least you manage to recover something.

    then you can save the file and convert back to excel.

    at least something.

    thanks for the heads up.

    definetly some file management issue between icloud and office365.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2023-11-17T17:35:33+00:00

    I recently edited an excel file on iCloud from my iPhone. The next time I tried to open it, I received a message indicating that the file was corrupt. I've tried all of the suggestions provided in this forum as well as several online excel file repair tools. NONE of these worked - file is still corrupt. This file has 2 years of critical data that is now apparently gone. It's very concerning to see that this is apparently a known issue that has been happening for a long time, has affected many people, and yet, there is still no resolution (at least that I could find). I'd like to hear directly from Microsoft as to what the root cause of this issue is and why there isn't a resolution yet? Or if there is a resolution, what is it?

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2023-11-17T19:04:32+00:00

    Only Apple/MS 365 knows what the deuce is going on. I am not aware of any resolution, only do it yourself workarounds to mitigate risk. My subscription is up soon, time to re-evaluate, although I don’t like Numbers. Be sure to routinely email your files to yourself and even add a version to Numbers. At least you’d have a point-in-time version.

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2023-11-29T13:26:47+00:00

    Just to say the same thing happened to me. I spent 8 hrs creating a project file on my Mac, saved it to iCloud and opened it opened it while on the move on my iPhone. I closed the file and now it cannot be opened using any device I have. It is disconcerting this has been going on so long without any party seemingly taking responsibility. iCloud is supposed to ensure my files are protected and now I feel that my entire back-up strategy has to change.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments