Transpose Function w/Hyperlink No Longer Working/Linking

Question

Transpose function with a hyperlink involved previously worked; now, I have to manually type in the tab name and cell range to have the transpose function work. What was updated to not allow the hyperlink to be clicked on and redirected to that page to select the cells??

Answer 1

Correct. When trying to complete the transpose formula, I want to link to a specific sub-tab set of cells to return that column on a main tab (I have about 300 sub-tabs in this file). When I go to click on the hyperlink to get to that specific tab, it does not "link". I have to manually type in the tab name and cell range. For a file this size, this is not a preferred method. I have to create transpose functions on almost 300 rows and typing them in manually is not a good use of my time. Again, the hyperlink feature within the transpose function used to work fine, now it does not. I have asked my IT and they are reviewing, but nothing has come back yet. Whether through Teams or in Excel by itself, this does not work. Version of Excel shown below.

These are just test screen shots, however they show the same 'error' as in my file.

Answer 2

Dear Elizabeth Alaimo,

Thanks for posting in Microsoft community. We are glad to help you.

Did you mean the transpose feature with a hyperlink is not clickable? Please attach screenshots to help us understand your concern better:

Meanwhile, we would like to confirm you Office version, please check through Files>Account and we could have a test on the same version and see if we could repro the scenario.

Your understanding and patience will be highly appreciated. I hope that you are keeping safe and well.

Sincerely,

Sean | Microsoft Community Moderator