Fix Excel Save As Not Opening the Folder Dialog
Question details
The user is unable to open the traditional folder selection dialog when using the 'Save As' function in Excel, with the application defaulting to OneDrive instead of local storage.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to save an Excel workbook to a specific local folder using the 'Save As' command.
- Observed behavior
- The local folder selection window does not appear, and Excel defaults to saving the file to OneDrive.
Determine if this issue happens with all Excel files or just a specific workbook, as shared file permissions can sometimes restrict local saving options.
Use the 'Browse' Option to Force the Local Folder Dialog
Bypass the default OneDrive save location by manually selecting the local PC option.
Microsoft 365 often attempts to streamline cloud saving by bypassing the traditional file explorer window. You can manually force the local folder dialog to appear by clicking the correct option in the Save As menu.
Click on 'File' in the top-left corner of Excel and select 'Save As' from the left-hand menu.
Instead of accepting the default OneDrive location presented on the screen, click on 'This PC' or click the 'Browse' folder icon.
The traditional Windows file explorer dialog will now open, allowing you to select your preferred local folder and save your workbook.
Set Excel to Save to Your Computer by Default
Adjust Excel settings to stop defaulting to OneDrive and always prefer local storage.
Run a Microsoft Office Repair
Use the built-in Windows repair tool if the Save As dialog is completely unresponsive for all files.
Try WPS Office for a Hassle-Free Local Saving Experience
If you're frustrated by Microsoft 365 constantly forcing cloud storage and burying the local save dialog, WPS Office offers a familiar, lightweight, and completely free alternative that respects your local storage preferences.
- 1. Download WPS Office: Visit the official WPS website and download the free installation package for your PC.
- 2. Install the Software: Run the installer and follow the brief on-screen instructions to set up WPS Office on your computer.
- 3. Open Your Excel Files: Launch WPS Spreadsheets and seamlessly open, edit, and locally save your existing .xlsx workbooks.
Frequently Asked Questions
Why does Excel keep trying to save my files to OneDrive instead of my hard drive?
Microsoft 365 is designed to integrate deeply with OneDrive, so it sets cloud storage as the default save location to encourage autosaving and real-time collaboration. You can change this behavior in File > Options > Save by checking 'Save to Computer by default'.
What if the Save As dialog is missing for only one specific Excel file?
If only one file is affected, it is likely due to file permissions or how the workbook was shared with you via OneDrive or SharePoint. Try copying the data to a brand new workbook or ask the file owner to grant you full downloading permissions.
Can a faulty Excel add-in cause the Save As dialog to disappear?
Yes, third-party Excel add-ins can occasionally interfere with core application functions like saving. You can test this by launching Excel in Safe Mode (hold the Ctrl key while opening Excel). If the Save As dialog works in Safe Mode, disable your add-ins one by one to find the culprit.
