PDA

View Full Version : Sleeper: Link updates



Shaolin
04-26-2005, 07:13 AM
Let's say there are 3 spreadsheets named A, B and C, which are all linked to one spreadsheet named Link. So, if there are any changes to be made on A, B or C, then Link automatically updates. Everything is cool and everyone is happy. Now, is there a way to be notified of the updates that Link made?

So, if I were to open Link and make the updates, is there a way of finding out the specific updates that Link made? Is there VBA code for this?

EricM
04-27-2005, 09:06 AM
I am faced with a simular problem just posed to me yesterday. Though this might not be what you want the route I am going to take is that when one of the child workbooks are open it will goto the parent file and update any fields as it loads. If this is the wrong approach someone please let me know.