Update Multiple Links

[Russ]

I have an Excel Application that contains multiple columns
of 15 cells vertically all these cells are linked and need
to be updated every month to a new data feed. The
field/cell names are the same every time. However, I need
to do an update to all the linked fields/cells so that the
data from the new data source gets reflected.

Is there a way to update all the linked fields/cells in
one fell swoop? Any suggestions will be welcome.

Thanks

 

[Steve Smallman]

Russ,

I suggest you look at the Indirect Function. This will allow you to place a
fully qualified reference to your data source on the sheet, say at A2, and
then have the data source reflected in the linked cells. As soon as you
change the data source to a valid new file, then the new data will be
reflected.

Steve