|Have you recently upgraded from 2003 to 2007, because:|
2003 Worksheet size 65,536 rows by 256 columns
2007 Worksheet size 1,048,576 rows by 16,384 columns
Selecting the whole worksheet is a bit excessive in my view.
It takes a lot more memory to link a whole sheet, even if a large portion of the cells are empty, then it does to link just a section.
Excel memory limits: