Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Repairing multiple broken hyperlinks in Excel Spreadsheet
I have limited knowledge of Excel macro writing etc. but have inherited an
Excel spreadsheeet with many hyperlinks to other worksheets on a server. They are performance management sheets for around 35 staff x 12 (months) plus quarterly, six monthly and annual) worksheets. Individual results aggregated to measure team performance etc. Everything working fine, but server is being relocated shortly and links will break. No problem to re-build the links using Find and Replace, but every worksheet is protected so has to be manually unprotected to allow this to happen (Don't they??). Can anyone please suggest a quicker way of opening and later closing each worksheet to allow Find and Replace to work? I do not have access to the person who wrote the original spreadsheets but I do have the passwords etc. Many thanks. -- Silver Beemer |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why do long hyperlinks get truncated on save in Excel? | Excel Worksheet Functions | |||
How do I map multiple XML elements in excel? | Excel Discussion (Misc queries) | |||
Addressing hyperlinks in excel | Excel Discussion (Misc queries) | |||
Print multiple excel charts within one sheet to fit to a page lik. | Excel Discussion (Misc queries) | |||
Multiple excel users can open the same file and edit at the same . | Excel Discussion (Misc queries) |