![]() If that is not the problem, you may want to turn off an option in Excel that causes the program to check hyperlinks whenever the workbook is saved. If this is the case, you will need to either change the name of the worksheet back to its original name, or you will need to recreate the hyperlinks to point to the renamed worksheet. ![]() If you later rename the worksheet, then the hyperlinks may not work as expected. When you create hyperlinks, each of them references the name of the worksheet you specify as the target. Check to make sure that you didn't rename the second worksheet-the one that is the target of the hyperlinks. First, you need to make sure that the problem isn't due to something you inadvertently did in your workbook. ![]() The second time the hyperlinks were all gray and would no longer work, and she's at a loss as to why this occurred. Those hyperlinks worked fine until Fanie saved and reopened the workbook. In the first worksheet she created hyperlinks to the second worksheet. Fanie has a workbook with two worksheets.
0 Comments
Leave a Reply. |