Excel when make shadow copy on filesrv hyper-links changes. string@GMT-2023.06.06-12.00.07(example)

Copper Contributor

Hello, when we make shadow copy on basis, the hyper-links changes. How to fix this?

We make shadow copy every hour and get broken links. 





1 Reply


When you create shadow copies on a file server, the hyperlinks in Excel may get affected because the shadow copy creates a snapshot of the files at a specific point in time, including their file paths. The new file paths created by the shadow copy will have a different timestamp appended to them, causing the hyperlinks to break.

To fix this issue, you can consider using relative hyperlinks instead of absolute hyperlinks in your Excel files. Relative hyperlinks specify the path relative to the location of the Excel file, rather than using an absolute file path.

Here is how you can create relative hyperlinks in Excel:

  1. Select the cell or text where you want to insert the hyperlink.
  2. Right-click on the selected cell and choose "Hyperlink" from the context menu.
  3. In the "Insert Hyperlink" dialog box, select "Place in This Document" on the left side.
  4. Browse or navigate to the target location within the same Excel file.
  5. Click OK to insert the relative hyperlink.

By using relative hyperlinks, the links will remain intact even if the file paths change due to shadow copies or other file operations.

Additionally, it is worth considering the impact of frequent shadow copies on your file server. If the shadow copies are causing disruptions and broken links, you might need to reevaluate the frequency or the method of creating shadow copies to avoid these issues in the future. Consult with your IT department or system administrator for guidance on adjusting the shadow copy settings to minimize the impact on hyperlinks and file paths.