Forum home » Delegate support and help forum » Microsoft Excel Training and help » Linking documents

Linking documents

ResolvedVersion 2007

Mon 18 Jun 2012, 16:26 Delegate Dawn said...

Dawn has attended:
Excel Advanced course

Linking documents

How can I get data that is updated in one file to automatically update in another

Fri 22 Jun 2012, 17:58 Trainer Anthony said...

RE: linking documents

Hi Dawn, thanks for your query. That can only happen if you have linked cells between the file and you need to open the files for the upates to occur. Other than that, you're looking at some VBA code to achieve it!

Hope this helps,

Anthony

Fri 29 Jun 2012: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

The Easiest Way to See a Sum or Average in Excel 2010

Did you know the quickest and most simple way of working out the average or sum of a set of numbers?

Highlight numbers in cells or type some numbers in cells and then look at the status bar at the bottom of the window. Here you will see a display of the average of the numbers, as well as a count of the cells and the sum of these cells.

View all Excel hints and tips

Linking documents

Linking documents

RE: linking documents

Excel articles

Excel tip:

The Easiest Way to See a Sum or Average in Excel 2010