How to Edit the Same Excel Workbook on Two Computers using OneDrive
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.

- 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.
Ensure both computers are connected to the internet and signed into the exact same Microsoft account so that OneDrive can sync your files properly.
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.
Open Excel and go to File > Account > Manage Settings. Ensure that connected experiences are enabled so Excel can communicate with online services.
Still under the Account menu, check if OneDrive is listed under Connected Services. If not, click 'Add a service' and link your OneDrive account.
Navigate to File > More > Options > Save. Check the box that says 'AutoSave OneDrive and SharePoint Online files by default on Excel'.
In the same Save options menu, uncheck 'Save to Computer by default' to ensure your workbooks always default to your cloud storage.
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.
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. Open WPS Spreadsheets: Launch WPS Office on your first computer and open the spreadsheet you want to work on.
- 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. 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.

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.




