How to refresh links across workbooks

A

apache007

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.
 
A

Ashish Mathur

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

links in protected workbooks 2
XL2000 Links Between Workbooks 2
copy 10 workbooks to a combined workbook 1
Excel 2007 - Linking workbooks 1
Worksheet relative reference 3
conversion from 2003 to 2007 1
How do I combine five Excel 2003 workbooks? 2
Aggregating data among multiple workbooks 1

Top