formula is as follows:

=VLOOKUP(A3, 'C:\Users\rickj\Documents\Master Price
Files\[master.xlsx]Main'!$A$3:$AS$19080, 1, FALSE)

The data is not sorted in any manner...(actually, what do you mean by sorted?)

"Niek Otten" wrote:

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