There is not relly a quick way in using the "= cell ref". But if you do use
the "=Cell Ref" method, whn you copy this to another cell, the cell ref
changes in repect to its placing. This may help you, by copying the "=Cell
Ref" to the other cells, and by using the $ either in front of the Column
Number / Row Number / Or both will determine on how the cell ref changes when
being copied to another cell.

Hope This Helps

"FTM" wrote:

Please could someone explain to me the difference between using the paste
link function & the €œ= cell ref€� function to link cells between workbooks. (I
find link paste useful as I can link large numbers of cells at one time where
as I have to use the €œ=€� method for each cell. Maybe there is a way to do
large numbers of cells with the €œ=€� method?)
Thanks