View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.setup
Rickoshae Rickoshae is offline
external usenet poster
 
Posts: 2
Default Vlookup takes too long to save

Hey guys,

I have a master file that holds prices and other data (text) which feeds
directly to 3 other files...If I update a price in the master file it
propogates through to the other files, using the vlookup function.
In theory this is great. However, when I save it, it takes too long...and I
mean long...each file has around 20,000 lines...

I am using Vista with 2007 office.

If I combine each file as a worksheet onto the same workbook...the file size
become around 50meg...and unworkable...any ideas?

Thanks, Rick