Fix an Excel OneDrive Workbook Opening on the Wrong Worksheet Tab
Question details
The user wants an Excel workbook stored on OneDrive to open on the preferred third worksheet rather than an older worksheet.
- Product
- Microsoft Excel and OneDrive
- Device & OS
- not provided
- Scenario
- A workbook with about 35 worksheet tabs repeatedly opens on a November worksheet. Moving the preferred tab to the first position has not helped.
- Observed behavior
- Hiding, unhiding, renaming, and moving worksheets have not changed which tab appears when the workbook opens.
Confirm that you are opening the same OneDrive file each time, and note whether it opens in desktop Excel or Excel for the web. Check the file extension for macro support, such as .xlsm or .xlsb, and close any other sessions of the workbook before testing.
Save the preferred active worksheet in desktop Excel
Use this first to update the workbook's saved active worksheet without changing the tab order.
Excel generally stores the active worksheet when the workbook is saved. Moving a tab changes its position, but does not necessarily change the worksheet shown when the file reopens.
Open the workbook from OneDrive. If it opens in Excel for the web, use the option to open it in the desktop app; the label may appear as Open in Desktop App or Open in app.
Click the worksheet tab you want to see at startup. If several tabs are selected, right-click a selected tab and choose Ungroup Sheets, then click only the preferred tab.
Choose File > Save or use the Save button. Wait for Excel to show that the file is saved and for OneDrive to finish syncing, if you are using a synced folder.
Close the workbook, then reopen that exact file from the same OneDrive location. Check whether the preferred worksheet is now active.
Check whether another session is replacing the saved worksheet state
Use this if selecting and saving the preferred tab works temporarily, but the workbook later opens on the old worksheet again.
Test a workbook copy and check startup macros
Use this when the original file still opens on the wrong worksheet after a controlled save-and-reopen test.
Work with multi-sheet Excel files in WPS Spreadsheets
WPS Office is a free, lightweight alternative for working with Excel files in a familiar spreadsheet interface. Open a separate copy in WPS Spreadsheets to navigate your worksheets and continue editing with an easy transition from Excel. WPS does not repair Excel's OneDrive session state, and macro-dependent workbooks need separate compatibility checks.
Frequently Asked Questions
Why did moving my preferred worksheet to the first position not work?
Worksheet order and the saved active worksheet are different settings. Click the preferred tab in desktop Excel, choose File > Save, wait for syncing to finish, then close and reopen the same file.
Can OneDrive make Excel reopen an older worksheet tab?
OneDrive syncing and coauthoring can be involved if another session saves a different workbook state or a save has not finished syncing. Close duplicate sessions, save from one desktop Excel window, and check OneDrive's Version history for later saves.
What if nobody else has opened the workbook?
Test a local copy using File > Save As or Save a Copy. Select the preferred worksheet, save, close, and reopen it. If the local copy also opens on the old tab, check startup macros and consider Open and Repair on the copy.
Can a macro force the workbook to open on a specific worksheet?
Yes. In a macro-enabled workbook, Workbook_Open, Workbook_Activate, or Auto_Open code can select a worksheet. Open Developer > Visual Basic and review those procedures, or ask the workbook owner to check them before making changes.
Will WPS Office fix the opening tab in my OneDrive Excel workbook?
WPS Office does not fix Excel's OneDrive session or coauthoring behavior. It is an alternative for opening and editing compatible Excel files. Use WPS Spreadsheets > Open to work with a separate copy, and verify any advanced features or macros before switching.
