![]() |
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