Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Linked Sheets not updating automatically
I have a workbook that is connected to other whorksheets.
But each time I open the worksheet, it would show that it could not find the whorksheet for update...so I have to manually link the sheets again... I do not mind doing this, but other users do not have the patience and I am looking for a way to stop this and make the link stick! Thanks. |
#2
|
|||
|
|||
Just a guess.
Your "sending" worksheets are in workbooks that are stored on a network drive. Try using the UNC name instead of the mapped drive. ="\\server\share\folder\.... instead of ="M:\folder\... Maybe it's because others link to that drive using a different letter???? New User wrote: I have a workbook that is connected to other whorksheets. But each time I open the worksheet, it would show that it could not find the whorksheet for update...so I have to manually link the sheets again... I do not mind doing this, but other users do not have the patience and I am looking for a way to stop this and make the link stick! Thanks. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update linked cells within a workbook??? | Links and Linking in Excel | |||
Two spreadsheets linked - moving cells | Excel Discussion (Misc queries) | |||
Multiple sheets selected | Excel Discussion (Misc queries) | |||
Updating sheets within a workbook | Excel Discussion (Misc queries) | |||
updating linked cells | Excel Discussion (Misc queries) |