What's the best way to do this without having to manually adapt every single hyperlink? I have Excel 2013 and am using INDEX-MATCH to access information from another workbook and am having trouble with updates I do not want to happen.
Is there a setting where they have a pop up window upon opening and it asks you if you want to update?
If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you.
For a version of this tip written specifically for earlier versions of Excel, click here: Updating Links.
Normally, if you have linked information in your workbook, the information is updated whenever you open the workbook.
I have tried to relink the 2 workbooks but still no luck.
The data in the timesheet only seems to update to a certain point from the "data workbook". Sorry, have tried to explain it has simply as possible.
The timesheet contains filters which work in alphabetical order and only update until the letter T. Thanks, Brit I've made an excel-file that has many hyperlinks to word-documents.Now I've been instructed these word-documents have to be moved to several other direcrories.There may be times when you need to update the links manually, however.You do this by following these steps: Excel Tips is your source for cost-effective Microsoft Excel training. You can find a version of this tip for the older menu interface of Excel here: Updating Links. Featuring the friendly and trusted For Dummies style, this popular guide shows beginners how to get up and running with Excel while also helping more experienced users get comfortable with the newest features. I'm using Excel 2010 and have a "data workbook" linked to a "timesheet workbook".To limit what is changed in the timesheets, data is inputted into the data workbook by admin and then the timesheets are updated with new information to stop anyone altering the timesheet.Somehow the link between the 2 has broken and won't update.