Guys Need help. I am a beginner excel user.
I created a excel sheet having a set of hyperlinks (around 50) which is hyperlinked to the different sections of the same sheet. By using "Move or Copy" option I created the copy of this sheet and given a different sheet name in the same excel file. But when I click the hyperlinks on the new sheet it is still hyperlinked to the same section on the old sheet. How can I change all these hyperlinks to the new sheet that I have created.