How to Make Excel Reuse the Last Save As Folder Instead of OneDrive
Question details
The user wants Excel to automatically remember and select the most recently used local folder during a 'Save As' operation, avoiding the default cloud save location.
- Product
- Excel 365
- Device & OS
- not provided
- Scenario
- Downloading or creating multiple files sequentially and needing to save them to the same custom local directory.
- Observed behavior
- Excel 365 ignores the previously used folder and defaults to the OneDrive location, forcing the user to manually browse through several folders for every file.
Take a moment to identify the exact file path of the local folder you want to use frequently, as pinning this location in Excel will provide the fastest workaround.
Pin the Custom Folder in Excel Save Locations
Since Excel 365 defaults to OneDrive and doesn't always automatically reopen the last used non-default folder, pinning your frequently used folder keeps it instantly accessible with one click.
In modern versions of Microsoft 365, the classic behavior of automatically opening the last used directory has been altered to prioritize cloud storage. Pinning your preferred folder effectively bypasses the manual browsing steps.
Click on 'File' in the top-left corner of the Excel ribbon and select 'Save As' from the left sidebar.
Click on 'Recent' (or 'Computer' depending on your layout) to view a list of folders you have recently saved files to.
Hover your mouse over the specific folder you want to reuse constantly. Click the pushpin icon that appears on the right side of the folder name. This folder will now stay permanently in your Pinned list for quick one-click access.
Set Excel to Default to Local Computer Storage
Prevent Excel from automatically selecting OneDrive by changing your global save options to prefer local computer storage by default.
Use WPS Office for Hassle-Free Local File Management
If Excel's forced OneDrive integration disrupts your workflow, try WPS Office. It provides a lightweight, user-friendly experience that respects your local save preferences without forcing cloud storage, while maintaining seamless compatibility with all Microsoft Excel formats.
- 1. Download and Install WPS Office: Get the free installation package from the official WPS website and install it on your computer.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx files with complete formatting preservation.
- 3. Save Locally with Ease: Use the Save As function and enjoy a traditional file management experience that respects your local folder choices.
Frequently Asked Questions
Why does Excel 365 default to OneDrive instead of my last folder?
Microsoft 365 is explicitly designed to encourage cloud storage to enable features like AutoSave, version history, and real-time collaboration. As a result, it prioritizes OneDrive over your most recently used local folders during the Save As process.
How do I find my last used folder if it wasn't pinned?
When you click 'File' > 'Save As', select the 'Recent' tab. Excel maintains a chronological list of your most recently accessed folders there, allowing you to easily click it instead of browsing through your entire hard drive.
Can I completely revert to the older Excel Save As behavior?
There is no built-in toggle in Microsoft 365 to exactly mimic older versions where the last used folder automatically opens every time. Checking 'Save to Computer by default' in Options > Save and heavily utilizing Pinned Folders is the closest workaround available.
