too many external links give "Not Enough Memory" error
 

I have 2 spreadsheets in the same folder:
box1.xls
data1.xls


box1.xls sheet5 cell p4 contains:
='[data1.xls]iControl'!F4

This external link range continues to
cell p37150 which contains:
='[data1.xls]iControl'!F37150

The above external links work fine on one WinXP PC which has 512MB
RAM.
But on another WinXP PC with 256MB RAM, Excel gives
a "Not Enough Memory" when I click on Yes to the question:

"The workbook you opened conatins automatic links to information in
another workbook. Do you want to update this workbook with changes
made to the other workbook?"
And #REF! appears in the range p9210 : p37150

To prevent this from happening, I understand that VBA code assigned to
a button can acheive the same results without the memory related
issues.
Also this will ensure that the data updates happen only when needed.

Is this true?
If yes, can you show me the VBA code to do this? Thanks.


---
Message posted from http://www.ExcelForum.com/