Forum Discussion
Saving Excel files on Mac
Hello everybody,
I am looking for help with saving my excel files on Mac.
I am using excel files with macros, but when I open it on OneDrive Windows and save it and after that I want open it on OneDrive Mac, it automatically turns off autosaving and shows two problems.
- An unexpected error occurred. Automatic refresh has been disabled for this Excel session.
and after that, when I want save file
- Errors occurred while saving file ///. Microsoft Excel can save this file only after removing or fixing some features. Click Continue to make corrections in a new file. To cancel saving the file, click the Cancel button.
It looks like file is broken, but every file I have cannot be broken.
I can't save it. This problem is with every macro file on Mac.
Has somebody this problem?
Thank you for your help
1 Reply
1. Check the file format: Make sure the file format is supported by Excel (e.g. .xlsx, .xls, .csv, etc.).
If the file format is not supported, try converting it to a supported format.
2. Check file permissions: Make sure you have write permissions to the target folder.
Right-click on the target folder, select “Show Profile”, and check the “Sharing and Permissions” settings.
3. Check storage space: Open “About this computer” > “Storage” to check if there is enough space on your hard disk.
If there is not enough space, delete unnecessary files or applications to free up space.
4. Use “Save As” function: Open Excel, click “File” > “Save As”.
Select the destination folder, enter the file name and click “Save”.
5. Check for Excel updates: Open Excel and click “Help” > “Check for Updates”.
Make sure Excel has been updated to the latest version.
6. Reset Excel Preferences: Close Excel.
Open Finder and navigate to ~/Library/Containers/com.microsoft.Excel/Data/Library/Preferences/.
Locate and delete the following files:
com.microsoft.Excel.plist
com.microsoft.office.plist
Restart Excel and the system will automatically generate a new preferences file.
7. Contact Microsoft Support: If none of the above methods work, it is recommended to contact Microsoft Support team with detailed error messages and screenshots for further assistance.
