Fix Excel Hyperlinks Redirected to AppData After a Crash
Question details
The user needs to restore local folder hyperlinks after Excel recovers a workbook from a crash.

- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- A recovered workbook contains hundreds or thousands of hyperlinks to local folders.
- Observed behavior
- Local folder links resolve to locations under AppData\Roaming\Microsoft, while network links remain correct.
Locate the original workbook and compare a few affected hyperlink addresses with their intended folder paths. Note whether the addresses are relative or share an incorrect prefix; different intended locations may need different corrections.
Reopen the original workbook and check its hyperlinks
Use this approach first if the original workbook is available and contains the links you need.
A recovered copy may resolve relative hyperlinks against the AutoRecover folder, commonly under AppData\Roaming\Microsoft\Excel. Reopening the original workbook can restore the expected resolution without editing every link.
In Excel, select File > Open and browse to the workbook's original folder rather than opening the recovered copy.
Click several links to different local folders and confirm that they open the intended locations.
Right-click a linked cell and choose Edit Hyperlink to inspect its Address. Where practical, replace a relative address with the correct absolute local path, then select OK.

Correct individual Excel hyperlink addresses
Use this method for a small number of links or when affected links do not share a predictable path prefix.
Replace a shared incorrect hyperlink prefix with VBA
Use a macro when many stored hyperlink addresses share the same incorrect prefix and you know the correct replacement.
Work with Excel workbooks in WPS Spreadsheet
WPS Office is a free, lightweight Office alternative with a familiar interface and support for Excel formats, making it easy to move existing workbooks between applications. It does not repair Excel's crash-recovery behavior.

Frequently Asked Questions
Why do my links point to AppData after Excel recovers the file?
Relative hyperlinks may be resolved against the recovered workbook's location. Excel AutoRecover files are commonly stored under AppData\Roaming\Microsoft\Excel, so a link that worked from the original folder may resolve differently.
How can I see whether a hyperlink address is relative?
Right-click the linked cell and select Edit Hyperlink. Inspect the Address field: an address without a drive or network root may be relative to the workbook's location.
Can Excel replace hundreds of hyperlink paths at once?
Excel has no dedicated built-in command to bulk-replace hyperlink addresses. A VBA macro or external script can update links that share a known incorrect prefix, but you should verify the results.
Will replacing an AppData prefix affect my network links?
A prefix-matching macro only changes stored addresses that begin with the prefix you enter. Check a sample of both local and network links afterward, and use a separate workbook copy for the change.




