You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

User profile for user: MattL1974
MattL1974 Author
User level: Level 1
18 points

Excel files corrupted when opened on iPad

I have a 2022 Macbook Air M2 and an iPad Air 2. All run the latest versions of the operating systems. My Mac has Excel 2021 and my iPad has the Excel 365 app. I have a number of Excel spreadsheets which are stored in the documents folder in iCloud drive. I regularly edit these files on my Mac, and occasionally also open and edit them on my iPad. This has worked without problems for the last six months until this week. Now if i open a file on my iPad, the next time I try and open it on my Mac or iPad I get an Excel error saying:


Alert - Excel cannot open the file ’Portfolio Valuation TEST.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.


This happens with any Excel file I open on the iPad. The first time i open it it is ok, and thereafter it becomes corrupted.

iPad Air 2, iPadOS 14

Posted on May 5, 2023 12:46 AM

Reply
Question marked as Top-ranking reply
User profile for user: Aries1st
Aries1st
User level: Level 1
43 points

Posted on Feb 29, 2024 9:46 AM

This is still a problem. The problem is with iCloud. If the Excel file is located on in a iCloud folder, and opened and modified in a Microsoft Office iOS app, it will corrupt it where you no longer can open it. However, if you do this on a file in a OneDrive folder, you are able to open and edit normally with out corrupting it. Additionally, you can use the Files app to go to a OneDrive folder and it does the same without corrupting it.


I'm not sure where the fault lies. But the problem is isolated to Microsoft files located on an iCloud folder edited in a Microsoft iOS app.


I hope this focuses someone's attention to this.

View in context

Similar questions

27 replies
User profile for user: jamesgbeaumont
jamesgbeaumont
User level: Level 1
36 points

Feb 5, 2024 7:01 AM in response to MattL1974

I have the same problem with Excel files stored in iCloud Drive getting corrupted (and file size truncated to 66kB) if any edit is performed and saved on iPad Excel. If the Excel file is stored in OneDrive then no problem, and the same edit performed on iPhone (Microsoft 365 or the standalone Excel app) does not cause a problem.


I have 2 Microsoft profiles: a personal one and a corporate one.


Seems this issue has been open for a long time, and still no resolution. Does anyone else have any further info?

Reply
User profile for user: Aries1st
Aries1st
User level: Level 1
43 points

Jul 4, 2024 12:58 PM in response to drheiser

Folks -


I don't have a solution. But I've discovered something new. I've learned the problem lies with the iOS/iPad Files app. I don't have any corrupt issues when I open an Excel file located in an iCloud Drive folder from within the native iOS/iPad Excel app. However, I can corrupt the file if I open the Excel file directly from the iOS/iPad Files app after editing it.


I would appreciate if someone else could confirm this behavior.


Apple, please pay attention to this thread and fix this ongoing problem.

Reply

Excel files corrupted when opened on iPad

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.
Learn more Sign up