I have run into an issue with ranges that link to foreign files when
used in VLOOKUPS in Excel 07. What is happening is that when you save
the file it seems like the data from the Linked file is somehow cached
in the saving file which balloons up the file size. I can limit the
size of the ranges and that directly impacts the saved file size but
the fact is I need to reference the data so trimming the range is not
helping my situation. An example of the file size change between 2003
and 2007 excel is 673kb to 8.9mg. The workbooks I am using are
converted from 03 but I have tested this issue in straight 07 and see
the same result. I guess I am looking for some VB code that can erase
the cached data before saving the file? If there are other options
that may help that would be appreciated as well.