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.