Hi Rick,

Show your formula

Is the data sorted?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Rickoshae" wrote in message
...
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