Document Editing Problems

Fix Excel Hyperlinks Redirected to AppData After a Crash

Steven ParkerSteven Parker Nov 22, 2026 868 views

Question details

The user needs to restore local folder hyperlinks after Excel recovers a workbook from a crash.

Fix Excel Hyperlinks Redirected to AppData After 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.
Before you start

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.

Solution 1Recommended

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.

1
Locate the original

In Excel, select File > Open and browse to the workbook's original folder rather than opening the recovered copy.

2
Test local links

Click several links to different local folders and confirm that they open the intended locations.

3
Inspect an affected address

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.

Reopen the original workbook and check its hyperlinks
Check unsaved changes: The original workbook may not include changes made before the crash. Compare it with the recovered copy before deciding which file to keep.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLS and XLSX filesWork with spreadsheet hyperlinks in a familiar interfaceUse a free, lightweight office suiteMove existing Office documents into a familiar workspace
microsoft office alternative - wps office

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.