How to Update Excel Pinned File Paths After Moving Folders
Question details
The user needs to update the file paths of pinned Excel workbooks after moving the files to a new directory.
- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Moving existing Excel files to a new folder while attempting to keep them accessible in the Pinned and Recent Files lists.
- Observed behavior
- Excel continues to display the old, invalid file locations in the Pinned section and search results, preventing the user from opening the moved files directly from the pinned list.
Before making any changes to the Windows Registry, it is highly recommended to create a backup of your registry to prevent system instability in case of accidental modifications.
Update Pinned File Paths via Windows Registry Editor
Manually edit the registry keys where Excel stores the Recent and Pinned file locations to point to the new folder paths.
Excel stores recent file and pinned-item information in the Windows Registry under the File MRU (Most Recently Used) and User MRU keys. By modifying these entries, you can correct the broken paths without losing your pinned list.
Press the Windows key + R to open the Run dialog. Type 'regedit' and press Enter. If prompted by User Account Control, click Yes.
In the left pane, navigate to 'HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Excel\File MRU' and 'HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Excel\User MRU'. Note: The '16.0' folder corresponds to Office 2016, 2019, and Microsoft 365. If you are using an older version, this number will be different (e.g., 15.0 for Office 2013).
Look at the data in the right pane. Pinned files generally have values that begin with '[F00000001]', while unpinned files begin with '[F00000000]'.
Double-click the registry string that corresponds to the file you moved. Carefully edit the file path portion of the string's Value data to reflect the new folder location, then click OK. Restart Excel for the changes to take effect.
Remove Old Pins and Repin Files from the New Location
If you prefer not to edit the Windows Registry, you can simply unpin the broken links and pin the files again from their new folder.
Experience Hassle-Free File Management with WPS Office
Tired of dealing with complex registry edits just to update a file path? WPS Office offers an intuitive interface where managing pinned files and recent documents is straightforward and seamless. It's a free, lightweight alternative that fully supports Microsoft Office formats.
- 1. Download and Install: Download WPS Office for free from the official website and run the quick installation.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheet and easily open any of your existing Microsoft Excel files without format loss.
- 3. Pin Important Files Effortlessly: Navigate to the Recent tab on the WPS homepage, hover over your important document, and click the pin icon to keep it accessible.
Frequently Asked Questions
Why do my pinned Excel files show an error when I try to open them?
When you move a pinned Excel file to a new folder, the pinned shortcut still points to the old location. Excel cannot automatically track moved files across your hard drive, leading to a 'file not found' or directory error when you attempt to open the old pin.
What does [F00000001] mean in the Excel registry keys?
In the Excel File MRU (Most Recently Used) registry keys, an entry's data string starting with '[F00000001]' indicates that the file is currently pinned to your recent files list. Conversely, files that are merely recent but unpinned start with '[F00000000]'.
Is there a way to clear all recent and pinned files in Excel at once?
Yes. You can clear unpinned files directly from Excel by right-clicking any file in the Recent list and selecting 'Clear unpinned Items'. To wipe everything including pinned items, you can delete the 'File MRU' registry key entirely, though this will permanently reset your recent files history.
