Click to See Complete Forum and Search --> : Covert Large Excel File


kwyeung
02-10-2003, 10:03 PM
I have a quite large excel file (5 col x 13000 row),
I find that the psiwin converter will die during converting,
So, what should I do?

Jim Cooke
02-11-2003, 12:09 AM
There may not be much you can do depending on how the Excel sheet is organized. Do you need all the formulas to work or just the values? If you copy the entire sheet and then copy, paste special, values, you will significantly reduce the complexity of the conversion and you may be able to convert the file. If you can reorganize the file so you have less rows but more columns, that may also help as the number of rows seems to be a bigger problem for PsiWin than the number of columns. Other than that, there are just some Excel files that are too complex to be converted by PsiWin.

Regards, Jim

diem
02-11-2003, 04:28 AM
You could look at nConvert for the Psion? Its shareware, not free, but it does have an Excel convertor that is better than the Psiwin one.

kwyeung
02-11-2003, 11:47 AM
I've solve the problem..... by paste value to a new sheet.
Thank you.....

But the convertion take too long (About 45Min.)

nConvert? I'd tried.... but it seems can't convert things well.... and take a few hours to complete it.