OneDrive File Issues

How to Edit the Same Excel Workbook on Two Computers using OneDrive

Kushani NimanthikaKushani Nimanthika Nov 2, 2026 871 views

Question details

The user needs to know how to synchronize and access a single Excel workbook across two different computers without relying on local storage.

How to Edit the Same Excel Workbook on Two Computers with OneDrive
Product
Microsoft Excel
Device & OS
not provided
Scenario
Editing the same spreadsheet from multiple devices in different locations.
Observed behavior
To ensure changes reflect across devices, the user needs the correct configuration to save files directly to a cloud service instead of a local hard drive.
Before you start

Ensure both computers are connected to the internet and signed into the exact same Microsoft account so that OneDrive can sync your files properly.

Solution 1Recommended

Configure OneDrive Sync and Excel AutoSave Settings

Set up your Excel application to save files to OneDrive by default and enable AutoSave so that all changes automatically synchronize across multiple devices.

By default, files stored only on a local hard drive cannot be accessed remotely from another computer unless a complex local share is configured. Using OneDrive bridges this gap, securely housing your workbook in the cloud so any device signed into your account can fetch the latest version.

1
Enable Connected Experiences

Open Excel and go to File > Account > Manage Settings. Ensure that connected experiences are enabled so Excel can communicate with online services.

2
Add OneDrive as a Connected Service

Still under the Account menu, check if OneDrive is listed under Connected Services. If not, click 'Add a service' and link your OneDrive account.

3
Adjust Save Options

Navigate to File > More > Options > Save. Check the box that says 'AutoSave OneDrive and SharePoint Online files by default on Excel'.

4
Disable Local Save by Default

In the same Save options menu, uncheck 'Save to Computer by default' to ensure your workbooks always default to your cloud storage.

5
Save and Sync

Save your current workbook to your OneDrive folder. Wait for the syncing status icon to show it is up to date before opening the file on your second computer.

Synchronization Time: Always allow a few moments for your file to finish uploading to OneDrive before turning off the first computer. If you open the file on the second computer too quickly, you may not see the most recent edits.
Seamless Multi-Device Editing

Sync and Edit Spreadsheets Across Devices with WPS Office

WPS Office offers a built-in Cloud service that automatically syncs your spreadsheets across computers, tablets, and smartphones. Easily access and edit your files anywhere without manual transfers.

  1. 1. Open WPS Spreadsheets: Launch WPS Office on your first computer and open the spreadsheet you want to work on.
  2. 2. Enable File Roaming: Click on the 'Tools' tab and select 'Sync to Cloud', or simply save the document directly to your 'WPS Cloud' directory.
  3. 3. Access Anywhere: Install WPS Office on your second computer, log into the same WPS account, and open the synced file from the Recent or Cloud folder to continue editing.
Fully compatible with Microsoft Excel file formats (.xlsx, .xls, .csv).Provides free cloud storage with WPS Cloud for instant multi-device access.Lightweight software with an intuitive, tabbed interface.Real-time File Roaming ensures your latest edits are always available on any device.
microsoft office alternative - wps office

Frequently Asked Questions

Why are my Excel changes not showing up on the second computer?

This usually happens if the file was saved to your local hard drive instead of OneDrive, or if one of the computers lost internet connection before the sync finished. Verify that AutoSave is toggled on in the top-left corner of Excel.

Can two people edit the same OneDrive Excel file at the same time?

Yes. If the workbook is stored in OneDrive or SharePoint and both users have Microsoft 365 with AutoSave enabled, Excel supports co-authoring, which allows simultaneous real-time editing.

How do I access a local hard drive file from a different computer without OneDrive?

Files stored exclusively on a local hard drive cannot be accessed remotely by default. You would need to configure a local network file share, use remote desktop software, or manually transfer the file via a USB drive.