Fix Excel Hyperlinks Breaking After File Server Shadow Copies in WPS Office
Question details
User needs to understand why Excel hyperlinks break when Windows file-server shadow copies create timestamped snapshot paths and how to make hyperlinks more stable.
- Product
- WPS Office Spreadsheets
- Device & OS
- Windows
- Scenario
- The user opens an Excel workbook stored on a Windows file server with shadow copies enabled. Hyperlinks point to absolute paths that change when snapshot folders are created.
- Observed behavior
- Hyperlinks break or point to a timestamped snapshot path such as @GMT-2023.05.15-13.00.07 that no longer exists after the snapshot changes.
Open the affected workbook in WPS Office Spreadsheets and identify whether the broken hyperlinks point to locations inside the same workbook or to external files. This helps you choose the correct relative link method before editing hyperlinks.
Switch Workbook Links to Relative Place in This Document Hyperlinks
Use this when hyperlinks target cells, sheets, or ranges within the same workbook; it avoids absolute timestamped paths entirely.
Shadow copy snapshots change the absolute path of files and folders. Links that reference a location in the same workbook do not depend on the file's full path, so they remain valid when the file server creates timestamped snapshot folders.
Open the affected workbook in WPS Office Spreadsheets, select the cell or object that contains the broken hyperlink, and click Insert tab > Link or Hyperlink.
In the Link dialog, select Place in This Document, then choose the target sheet and cell reference or defined name from the list.
Click OK or Apply, then hold Ctrl and click the link to verify that it jumps to the correct sheet and cell without using a full file path.
Keep External Hyperlinks Relative with a Stable Folder Structure
Use this when hyperlinks point to other files; a stable relative folder structure prevents broken links after snapshot paths change.
Review Shadow Copy Configuration with Your IT Administrator
Use this when the server continues to expose timestamped snapshot paths to users; configuration changes can reduce path instability.
Fix Excel Hyperlink Paths in WPS Office Spreadsheets
WPS Office Spreadsheets can open Excel workbooks and lets you replace absolute hyperlinks with stable relative links, so file server shadow copy timestamp paths do not break navigation.
- 1. Open the workbook in WPS Office Spreadsheets: Download and install WPS Office, right-click the affected Excel file, and choose Open with > WPS Office Spreadsheets.
- 2. Select the broken hyperlink: Click the cell or object containing the hyperlink and open the Insert tab > Link dialog.
- 3. Relink to a stable target: Choose Place in This Document for internal links, or browse to the target file in the shared folder for external links.
- 4. Save in Excel format: Press Ctrl+S and keep the default Excel .xlsx/.xls format so the fix remains compatible with Microsoft Excel.
Frequently Asked Questions
Why does an Excel hyperlink suddenly point to a @GMT timestamp path?
Windows file server shadow copies create snapshot folders with timestamped paths like @GMT-2023.05.15-13.00.07. If the hyperlink stores the absolute path, it may change when the snapshot is accessed.
Can I fix this without changing the server shadow copy configuration?
Yes. In WPS Office Spreadsheets, use Insert > Link > Place in This Document for same-workbook links, or keep external files in a stable relative folder structure.
Do relative hyperlinks work when I send the workbook to another computer?
Relative external links work only if the target files keep the same folder structure and are moved together. Internal Place in This Document links remain intact inside the workbook.
Does WPS Office preserve my Excel hyperlinks when saving?
WPS Office Spreadsheets opens and saves .xlsx/.xls files and preserves hyperlink settings. Use the Insert > Link dialog to update broken paths and save normally.
What should I ask my IT administrator to check?
Ask them to review the shadow copy schedule, snapshot visibility in user shares, and whether users are opening files from timestamped snapshot folders instead of the live share.
