Auto Update links from other Workbooks without Updating Values every time

Hi Guys,

I have a setup for my customers' records.

I have a workbook for wach customer which stores data and graphs about that customer.

I then have a Master sheet which is a seperate workbook that contains a table showing a breakdown of each customer's information on each row.

The information on the Master sheet is referenced to each file

='C:\..............Account324.xls]Data'!$C$11

When I have the Master sheet open I go into a workbook for an account, change some values, save then exit, however when I do this it does not update my master sheet. I have to go in and click

Data -> Edit Links -> Update Values

Is there a way to set Excel 2007 to Auto update these values, so when I change soemthing on one of the Account Workbooks, it will auto update on the Master Sheet Automatically?

Thanks for you help

here's a quote from a helpful page (if you want i can send you the link)

Updating Links

The purpose of a link is to avoid duplicating formulas and data in multiple worksheets. If one workbook contains the information you need, you can use a link to reference the data without recreating it in another workbook.

To be useful, however, the data in the dependent workbook should always reflect what actually is in the source workbook. You can make sure of this by updating the link, as explained here:

* If both the source and the dependent workbooks are open, Excel automatically updates the link whenever the data in the source file changes.
* If the source workbook is open when you open the dependent workbook, Excel automatically updates the links again.
* If the source workbook is closed when you open the dependent workbook, Excel displays a Security Warning in the message bar, which tells you automatic updating of links has been disabled. In this case, click Options, click the Enable this Content option, and then click OK.

TIP

If you always trust the links in your workbooks (that is, you never deal with third-party workbooks or any other workbooks from sources you don't completely trust), you can configure Excel to always update links automatically. To begin, choose Office, Excel Options, click Trust Center, and then click Trust Center Settings. In the Trust Center dialog box, click External Content and then click to activate the Enable Automatic Update for All Workbook Links option. Click OK and then click OK again.

Thanks Kroz,

I think using these terms:

I have the Dependant workbook open.

I open the Source Workbook using a hyperlink on the Dependant workbook sheet.

I edit the Data in the Source Workbook.

I save and close the Source Workbook.

I return to the Dependant workbook and nothing has updated. I have to go into update Values to retrieve the information.

I dont understand why as my trust centre is set to allow all.

Any Ideas?

Could it be the number of workbooks involved? I have 500 (source) workbooks feeding one master sheet.