OneDrive File Issues

Fix Excel on OneDrive Opening Worksheets at Random Cells

Maira Mehtab Sep 22, 2026 868 views

Question details

The user is experiencing an issue where an Excel workbook stored on OneDrive does not remember the last active cell location and opens at a random or different cell instead.

Product: Microsoft Excel / OneDrive
Device & OS: not provided
Scenario: Opening a previously saved Excel workbook directly from OneDrive.
Observed behavior: Each worksheet in the workbook opens at a random or different cell rather than the specific location where the workbook was last saved.

Before you start

Before troubleshooting, check if anyone else is currently co-authoring the file, and ensure your OneDrive sync client and Excel desktop application are fully updated.

Solution 1Recommended

Verify Environment and Test a Local Copy

Determine if the issue is specific to Excel for the Web or a synchronization glitch by downloading a local copy of your workbook.

Excel for the Web sometimes handles active cell memory differently than the desktop application, especially when browser caching issues occur or co-authoring is enabled. Isolating the environment helps identify the root cause.

Open in Excel for the Web

Navigate to your OneDrive online, locate the affected workbook, and click to open it in your browser.

Download a local copy

Go to 'File' > 'Save As' and select 'Download a Copy' to save the file to your computer's local storage.

Test in the desktop app

Open the downloaded local copy using the Excel desktop app. Select a specific cell, save the file, close it, and reopen it to see if the active cell location is preserved.

Solution 2

Save a Fresh Copy to OneDrive

Creating a new copy of the workbook can resolve underlying metadata corruption that prevents Excel from saving the last active cell position.

Free Microsoft Office alternative

Try WPS Office for Reliable Spreadsheet Management

If Microsoft Excel and OneDrive continue to cause frustrating navigation or syncing bugs, consider switching to WPS Office. It provides a highly compatible, stable, and free alternative for all your spreadsheet needs without these cloud-sync glitches.

1. Download WPS Office: Visit the official WPS website and install the free office suite.
2. Open your spreadsheets: Open your existing .xlsx files directly in WPS Spreadsheet; no conversion is required.
3. Save securely: Save your work locally or sync it reliably via WPS Cloud, preserving your exact workspace layout.

Completely free and lightweight office suiteSeamlessly compatible with Microsoft Excel (.xlsx, .xls) formatsReliable view-state saving so you never lose your active cell positionFamiliar user interface requiring zero learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel for the Web not save my last cell position?

Excel for the Web operates within a browser environment where cache clearing, session timeouts, or limited view-state memory can cause a workbook to default to cell A1 or a seemingly random cell upon reopening.

Does co-authoring affect where an Excel file opens?

Yes. If multiple users are editing a shared OneDrive file simultaneously, Excel may sometimes open the workbook at the cell location where another user is actively working or last made an edit.

Can I force my Excel sheet to open at a specific cell?

If you are using the desktop version of Excel, you can use a simple VBA macro (Private Sub Workbook_Open) to command the file to always select a specific worksheet and cell whenever the workbook is opened.

Document & File Issues