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

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

On Mar 19, 1:08*am, wrote:
hi folks

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

thanks

Hi,

I think your new excel file might be damaged. If necessary, you can
try a popular Excel file recovery tool called Advanced Excel Repair to
repair your Excel file. It is a powerful tool to repair corrupt or
damaged Excel files.

Detailed information about Advanced Excel Repair can be found at
http://www.datanumen.com/aer/

And you can also download a free demo version at http://www.datanumen.com/aer/aer.exe

Alan