Fix Pinned Excel Files from OneDrive Disappearing After Closing
Question details
Excel files stored on OneDrive disappear from the pinned list after they are opened and closed, requiring the user to pin them again.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Accessing frequently used OneDrive files via the Excel pinned recent list.
- Observed behavior
- Pinned files vanish from the list after the application is closed, and the problem persists even if the files are manually pinned again.
Ensure your Microsoft Office application is updated to the latest version and that your OneDrive sync client is actively running and fully synced.
Run Excel in Safe Mode and Disable Add-ins
Third-party add-ins might interfere with Excel's ability to save application preferences, such as the pinned files list. Running in Safe Mode helps identify this conflict.
Safe Mode bypasses settings and add-ins that might be causing the application to drop your pinned items. If the issue is resolved in Safe Mode, you will need to disable your add-ins one by one to find the culprit.
Press the Windows key + R to open the Run dialog. Type 'excel /safe' and press Enter. Pin a file from your OneDrive, close Excel, and reopen it in normal mode to see if the file remains pinned.
If the file remained pinned after testing in Safe Mode, go to File > Options > Add-ins in the normal Excel window.
At the bottom of the window, select 'COM Add-ins' from the Manage drop-down list and click 'Go'. Uncheck all add-ins and click OK. Restart Excel and test pinning files again.
Perform an Office Online Repair
Repairing the Office installation can resolve corrupted registry keys or application files that cause the pinned list to reset automatically.
Perform a Windows Clean Boot
Background programs or services may conflict with Excel and OneDrive syncing. A clean boot disables non-essential startup programs to rule out software conflicts.
Switch to WPS Office for a Reliable Spreadsheet Experience
If Microsoft Excel continues to drop your pinned files or struggles with cloud syncing, WPS Office provides a lightweight, highly compatible, and free alternative with a built-in, reliable document manager.
- 1. Download WPS Office: Visit the official WPS website to download the free installation package.
- 2. Install the Application: Run the downloaded installer and follow the simple on-screen instructions to complete the setup.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheets, open your existing .xlsx files, and pin your favorites securely without them disappearing.
Frequently Asked Questions
Why are my pinned files disappearing in Office?
This usually happens due to conflicting third-party add-ins, corrupted Office installation files, or issues with cloud synchronization paths when using OneDrive.
How do I clear the unpinned recent files list without losing pinned items?
Right-click any unpinned file in the Recent list and select 'Clear unpinned items'. Your pinned files will remain intact while the rest of the list is cleared.
Can I increase the number of recent and pinned files shown in Excel?
Yes. Go to File > Options > Advanced, scroll down to the Display section, and adjust the number next to 'Show this number of Recent Workbooks'. The maximum limit is 50.
Does OneDrive syncing affect pinned Office files?
Yes. If the file path changes locally or if the OneDrive sync is interrupted, Office may fail to locate the file upon launch and subsequently remove it from the pinned list to prevent broken links.
