linking one worksheet to lots of workbooks(worksheets)

J

johnd

I noticed slow response from my workstation when cell linking to many
different workbooks to one worksheet, is there any recommended RAM for
this??? The source is on a network and so is the destination workbook.
 
N

Nick Hodge

John

I suspect little you do will improve this, certainly if you have 256mb and a
decent processor it will not help. You should check the network speed and
traffic and also be aware that linking workbooks requires significant effort
on the part of Excel especially if using generally slow functions like IF
and VLOOKUP, etc

--

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
 
Top