Can you open a new workbook at the same time as the existing one? If
so, then you could put a formula in the new book along the lines of:

=[filename1.xls]Sheet1!A1

in cell A1, where you are bringing the data from your VLOOKUP
formulae, and then copy this down. Then you can try to fix values in
the new workbook (you can close the first workbook once you have put
the formulae in the second).

Hope this helps.

Pete

On Mar 18, 5:08*pm, wrote:
hi folks

i have generated a large data set in excel (ie. the maximum ~65K lines
in excel mac 2004) using VLOOKUP. *i want to now convert this data to
values and move it into another program for analysis. *however,
everything i do leads excel to hang interminably. *can i extract the
data somehow, or am i out of luck?

thanks