Vlookups to Excel Version 3 files.

N

Naz

I use a system that on a daily basis creates an Excel
version 3 file containing cost centers and their budgets.
When I do vlookups from other Excel 97 files to this file
it takes a long time for the sheet to calculate. If I save
the Excel V3 file as Excel 97 its OK, and if the Excel V3
file is open before the 97 file its OK. I don't want to
have to constantly save the V3 file as 97 (I may not be
around to do that always)
Does anyone know how to resolve this.

Thanks

Naz
 
Top