Hi Team,
I have a workbook with couple of external references. The external references are driven by few fields in master workbook. Results using these values are displayed back in master workbook.
My concern is, I have to make sure all the external references has to be open before I carry out changes in master workbook. I have dont open external references, my results goes for toss..since the expected results from external references does not get updated.
Q: Is there any way without opening external references files have these updated with new values in master workbook?
If answer is YES, please help me with the information.![]()
Bookmarks