OneDrive File Issues

How to Save Excel Files Only to a Local Hard Drive

Maira Mehtab Sep 29, 2026 868 views

Question details

The user wants to save Excel workbooks directly to a local hard drive instead of cloud storage services like OneDrive or SharePoint.

How to Save Excel Files Only to a Local Hard Drive

Product: Microsoft Excel
Device & OS: not provided
Scenario: Saving new or existing Excel workbooks.
Observed behavior: Excel defaults to saving files to OneDrive or SharePoint, requiring the user to manually navigate to local folders every time.

Before you start

Ensure you are using the Excel desktop application, as Excel for the web automatically saves to the cloud and does not support local-only saving by default.

Solution 1Recommended

Change the Default Save Location in Excel Options

Modify Excel's built-in settings to automatically default to your local computer when saving files.

By default, modern versions of Microsoft Excel prioritize saving documents to OneDrive. By tweaking your save options, you can bypass the cloud and ensure your files stay strictly on your local hard drive.

Open Excel Options

Launch the Excel desktop app. Click on the 'File' tab in the top left corner, then select 'Options' located at the bottom left of the menu.

Access Save Settings

In the Excel Options dialog box, click on 'Save' in the left-hand menu pane to view your workbook saving preferences.

Enable Local Saving

Check the box next to 'Save to Computer by default' to prevent Excel from automatically suggesting OneDrive or SharePoint.

Set Default Local Folder

In the 'Default local file location' field, enter the file path of your preferred local folder (for example, C:\Users\YourName\Documents\). Click 'OK' to apply and save your changes.

Change the Default Save Location in Excel Options

Check Your File Path: Ensure that the local folder path you choose is not actively synced by the OneDrive desktop client, otherwise your files will still end up in the cloud.

WPS Spreadsheet Local Saving

Easily Save Spreadsheets Locally Using WPS Office

WPS Office respects your privacy and storage preferences by allowing you to easily save files directly to your local hard drive. It is a powerful, free alternative that offers seamless compatibility with all your existing Microsoft Excel files.

1. Download WPS Office: Get WPS Office for free from the official website and install it on your computer.
2. Open WPS Spreadsheet: Launch WPS Spreadsheet and either create a new workbook or open an existing Excel file.
3. Access the Save Menu: Click on 'Menu' in the top-left corner and select 'Save As' from the dropdown list.
4. Select a Local Path: Click on 'Local Path' and browse to the specific folder on your hard drive where you want to keep the file.
5. Save Your File: Confirm the file name and click 'Save'. Your file is now securely stored on your local computer.

Save directly to your local hard drive without forced cloud syncing.Seamlessly open, edit, and save Microsoft Excel (.xlsx, .xls) formats.Familiar user interface makes it easy to switch without a learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel automatically save my files to OneDrive?

Microsoft Office enables cloud-saving by default to encourage the use of OneDrive for backup, AutoSave, and real-time collaboration. If you prefer offline storage, you must manually change the save options to default to your local computer.

Can I save locally when using Excel for the web?

No, Excel for the web operates entirely in the cloud and automatically saves all changes to OneDrive or SharePoint. To save a local copy, you must use the 'Download a Copy' option in the File menu.

Will turning on 'Save to Computer by default' disable AutoSave in Excel?

Yes. The AutoSave toggle in Microsoft Excel only works when files are actively stored and synced in OneDrive or SharePoint. If you save your files locally, you will need to manually save your progress.

Document & File Issues