When you open those subworkbooks, you'll be prompted (if you use that setting)
to see if you want to update the links.
So you could open, update the links and save/close.
(Or just wait until you really want to use that subworkbook.)
Jason wrote:
I have one master workbook and several sub-workbooks. All the sub-workbooks
get assumptions from the master workbook and return the result to master
workbook. Is there a way to automatically update all the sub-workbooks after
I change some assumptions in the master workbook and return the new result to
master workbook?
I've tried Edit/Link/Update now in the master workbook after I changed the
assumptions, it doesn't work.
Any help will be greatly appreciated.
Jason
--
Dave Peterson
|