Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Links in Excel
I've got several spreadsheets that link to one 'master' spreadsheet.
They're all kept on our work X: drive, which is the shared drive for the whole organisation. However, the automatic links have a problem, in that every time I open the master spreadsheet that contains the links, I have to manually find each linked spreadsheet, it doesn't automatically update. Now, I can't see anything wrong with the source file descriptions and I can't think of what else it could be. Does anyone have any advice or tips? Any help would be greatly appreciated. thankyou in advance |
#2
|
|||
|
|||
try this - http://www.oaltd.co.uk/MVP/Default.htm - findlink.zip
"Kieron" wrote: I've got several spreadsheets that link to one 'master' spreadsheet. They're all kept on our work X: drive, which is the shared drive for the whole organisation. However, the automatic links have a problem, in that every time I open the master spreadsheet that contains the links, I have to manually find each linked spreadsheet, it doesn't automatically update. Now, I can't see anything wrong with the source file descriptions and I can't think of what else it could be. Does anyone have any advice or tips? Any help would be greatly appreciated. thankyou in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make excel insert links | Excel Discussion (Misc queries) | |||
How do I remove external links from Excel 2000 workbook? | Excel Discussion (Misc queries) | |||
How do you set up a data excel sheet that links to a presentation. | Excel Worksheet Functions | |||
VB Automation is Whacking out my Excel Environment | Excel Discussion (Misc queries) | |||
How do I Break links Using Excel 2000 | Excel Discussion (Misc queries) |