ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Hyperlink loses reference (https://www.excelbanter.com/excel-worksheet-functions/8035-hyperlink-loses-reference.html)

Jami's Mom

Hyperlink loses reference
 
I have a workbook with multiple worksheets and several hyperlinks to cells.
For example, 'HOME' to take me back to cell A1 of 1st worksheet.
Occasionally, when I open the Workbook, Excel gives me the error 'Reference
is not Valid' for many of my links. When I hover over the cell, the path is
correct, but I have to edit the Hyperlink and input the target cell again,
then reformat the font (again). What causes this? What's the fix? Did I
mention it very annoying and time-wasting?


All times are GMT +1. The time now is 08:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com