Dear all,

I have workbook A that has plenty cell references in other workbooks (about
10 workbooks approx). Currently, in order to refresh data in workbook A, I
have to open other workbooks that have reference in workbook A.

Is there any tip to easily manage these references across workbooks?

Really appreciate the help and advice.

Hi,

One way is to save all the files as a workspace (File Save workspace).
Open all the 10 files and on any file go to File Save workspace. Now this
workspace file will basically save the locatio of all the 10 files. Next
when you want to open any one of the 10 files, click on the workspace file
and all 10 files will open up.

Not quite sure of whether this answers your question or not.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"apache007" wrote in message
...
Dear all,

I have workbook A that has plenty cell references in other workbooks
(about
10 workbooks approx). Currently, in order to refresh data in workbook A, I
have to open other workbooks that have reference in workbook A.

Is there any tip to easily manage these references across workbooks?

Really appreciate the help and advice.