I have created a hyperlink to another worksheet within the same workbook. When I modify the worksheet layout, such as hide row & column headers or freeze pane in a different location, and then click on the hyperlink to go to that worksheet, the new formatting does not appear. I have tried everything I can think of, even deleting the original hyperlink and creating a new one. Nothing seems to work. Please help!