I would like to be able to open my linked sheet in a new window when I select the hyperlink from a report.
I have very lengthy reports that pull in hundreds of sheets. When reviewing data, I'll expand and collapse grouped data as I work my way down the report. I occassionally need to navigate to the underlying sheet to drill down into details further. When I go back to my report from the sheet, I completely lose my place and any collapsing/expanding I might have done along the way for various reasons (e.g. to remember to go back and check something later).