I a file that is linked to a very large file. I do a vlookup from the first
file. When i save the first file the save is very slow and the resulting
file large but not as large as the Large file that it is linked to (about
80%).

Any ideas on how to speedup the save or a better was to do a lookup in a
large file and avoid the large resulting file?

jack