| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| Moving rows with Hyperlink doesn't move hyperlink address | Excel Discussion (Misc queries) | |||
| Removing hyperlink | Excel Discussion (Misc queries) | |||
| Using a formula in a Hyperlink Cell reference | Excel Discussion (Misc queries) | |||
| How do I reference multiple rows | Excel Worksheet Functions | |||
Threaded Mode
