One of our users has an Excel spreadsheet that she hyperlinks to a Word document. These were originally created in Office 98. Now that we are using Office XP, the hyperlinks don't work. She could go in and edit each one, but there are close to 200 links. Is there a way to edit them all at once, or does each one have to be done separately?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Edit 200 hyperlinks
- Thread starter wkszd
- Start date
You could also look to the MS Office forum for expert help.
I echo Linney's comment, however post some more information about why it doesn't work and what would need replacing in the hyperlink because you may be able to do what you need by way of a macro but it is hard to say without the extra information.
--------------------------------------
"Insert funny comment in here!"
--------------------------------------
--------------------------------------
"Insert funny comment in here!"
--------------------------------------
- Status
Similar threads
- Locked
- Question