How to Fix Excel Pinned Files Keep Disappearing
Question details
Users are experiencing an issue where pinned Excel files unexpectedly disappear from the Recent or Pinned items list, despite the actual files remaining intact in their original folders.
- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Attempting to access frequently used spreadsheets from the pinned list after performing daily operations like saving new file versions.
- Observed behavior
- Pinned files vanish from the Excel pinned items list, specifically after using the 'Save As' function or due to corrupted recent item caches in Windows.
Ensure you note down the exact folder locations of your most critical spreadsheets before troubleshooting, as clearing the recent item cache will temporarily reset your document viewing history.
Use Copy and Paste Instead of 'Save As'
Prevent Excel from automatically unpinning your original file when saving a new version to a network drive or local folder.
A common trigger for disappearing pinned files is using the 'Save As' command. When you save a pinned document under a new name or in a new location, the system sometimes updates the recent file reference to the newly saved path, causing the original file to drop from the pinned list.
Open File Explorer and navigate to the folder containing your pinned Excel spreadsheet.
Right-click the file and select 'Copy', or simply press Ctrl+C on your keyboard.
Navigate to your target network drive or new folder, right-click an empty space, and select 'Paste' (or press Ctrl+V).
Rename the newly copied file as needed and open it to make your edits. This leaves the original file untouched and safely pinned in Excel.
Clear the AutomaticDestinations Folder
Reset the Windows Quick Access and recent files cache by deleting potentially corrupted system files.
Switch to WPS Office for Reliable File Management
If Microsoft Excel's pinned files keep disappearing and disrupting your workflow, consider switching to WPS Office. It provides a highly stable document tab system, reliable recent file pinning, and full compatibility with all your existing Excel spreadsheets—completely free of charge.
- 1. Download and Install: Click the download button to get WPS Office Free and follow the simple installation wizard.
- 2. Open WPS Spreadsheet: Launch WPS Office and click on 'Spreadsheet' to access the familiar Excel-like interface.
- 3. Pin Your Files Securely: Open your existing .xlsx files, navigate to the Recent files list on the home screen, and click the pin icon to keep them permanently accessible.
Frequently Asked Questions
Why do my pinned files disappear when I use 'Save As' in Excel?
When you use 'Save As' to create a new version of a file, Excel's system sometimes shifts the active reference to the newly created file path. This can inadvertently remove your original file from the pinned list, causing it to seemingly disappear.
Where are Excel pinned files stored in Windows?
The background data and cache for pinned and recent files in Windows are stored in a system folder located at `%AppData%\Microsoft\Windows\Recent\AutomaticDestinations`.
Will reinstalling Microsoft 365 permanently fix the pinned files issue?
Often, reinstalling Microsoft 365 does not permanently resolve the issue. The problem is usually tied to the Windows recent files caching mechanism and the specific way 'Save As' handles active document paths, rather than a corrupted Excel installation.
Are my disappeared pinned files permanently deleted?
No. When a file disappears from the pinned list, only the shortcut reference is removed from Excel's history. Your actual Excel spreadsheet remains safely in its original folder location on your hard drive or network.
