'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Recover Lost Excel Work on Mac After Reverting to Older Version
Question details
User needs to recover unsaved Excel work that was lost when the file unexpectedly reopened as an older version after a macOS permission prompt.
- Product
- Microsoft Excel
- Device & OS
- macOS
- Scenario
- Editing and saving an Excel workbook or CSV file that is stored in the Mac Downloads folder.
- Observed behavior
- Excel displays a "Grant Access" prompt for the CSV file and subsequently reopens an older iteration of the spreadsheet, wiping out recent progress despite repeated saves.
Immediately stop making new edits to the current file to prevent overwriting hidden temporary backups, and check if your Mac's Time Machine was running during your work session.
Restore the File Using Excel's AutoRecover Folder
Retrieve the most recent automatically saved backup of your workbook from Mac's hidden AutoRecover directory.
Microsoft Excel for Mac automatically creates temporary backup copies of your working files at set intervals. If your file reverted to an older state due to permission conflicts, the AutoRecover folder may contain a more recent snapshot of your lost work.
Open Finder on your Mac. Click on "Go" in the top menu bar, and select "Go to Folder" from the drop-down menu.
Type the exact path: ~/Library/Containers/com.microsoft.Excel/Data/Library/Preferences/AutoRecovery/ and press Return.
Look for files starting with "AutoRecovery save of" followed by your workbook's name. Double-click the file to open it in Excel.
Once opened, immediately click "File" > "Save As" and save the recovered workbook to your Documents or Desktop folder.
Resolve macOS "Grant Access" Prompts for CSV Files
Move your files to trusted macOS directories to prevent Excel from locking the file and reverting to older states in the future.
Restore an Older Version via OneDrive or SharePoint
If your file was synced to cloud storage, you can roll back to a previous state before the regression occurred.
Prevent File Loss with WPS Office for Mac
Skip the frustrating macOS permission errors and unreliable auto-saves. WPS Office provides a lightweight, highly compatible alternative to Microsoft Office for Mac users, offering seamless CSV handling and robust built-in local backups to keep your data safe.
- 1. Install WPS Office: Download and install WPS Office for Mac from the official website.
- 2. Open your spreadsheet: Launch WPS Spreadsheet and drag your CSV or Excel file directly into the workspace.
- 3. Work securely: Edit and save your work securely with WPS's reliable built-in Auto-Backup enabled by default.
Frequently Asked Questions
Why does Excel constantly ask to "Grant Access" on my Mac?
macOS has strict privacy protocols (sandbox features) that restrict apps like Excel from accessing folders like Downloads or external system drives without explicit user permission. Moving files to the Documents or Desktop folder usually resolves this issue permanently.
Where are Excel temporary files stored on a Mac?
Excel temporary and AutoRecover files on Mac are typically stored in the hidden library path: ~/Library/Containers/com.microsoft.Excel/Data/Library/Preferences/AutoRecovery/.
Can I recover an overwritten Excel file without OneDrive?
If the file was not saved to OneDrive or SharePoint, your best options are checking the local AutoRecover folder via Finder, or restoring the file using Apple's Time Machine backup if it was active during your editing session.
