Hi All,
For about 24 months, I have been using the EXCELCNV.EXE command line program to convert XLS files to XLSX files so that I can use them in Power BI as datasets. I use a series of batch scripts to convert Excel files that are downloaded from my web application (that I cannot make the Excel file come down as xlsx).
33% of the time over those 24 months, excelcnv.exe worked instantaneously on file conversions.
66% of the time the conversion takes FOREVER (really, between 3-5 minutes).
The files themselves haven't grown in size. They are about the same size as they were 24 months ago.
It is maddening. In the beginning, it worked quickly, then a MS update pushed down and it the conversion lagged. Then a new update would come down and it went back to instantly again. I am now in a long period of the LONG conversions. Repairing MS Office hasn't done anything and a reinstall hasn't either.
I have done searching over the Internet and haven't found anyone experiencing this problem. Anyone have any ideas? (I put this in Excel because it is a file that comes with Excel, but if you think I should put it in the Power Tools forum, I can do that too).
Thanks!
For about 24 months, I have been using the EXCELCNV.EXE command line program to convert XLS files to XLSX files so that I can use them in Power BI as datasets. I use a series of batch scripts to convert Excel files that are downloaded from my web application (that I cannot make the Excel file come down as xlsx).
33% of the time over those 24 months, excelcnv.exe worked instantaneously on file conversions.
66% of the time the conversion takes FOREVER (really, between 3-5 minutes).
The files themselves haven't grown in size. They are about the same size as they were 24 months ago.
It is maddening. In the beginning, it worked quickly, then a MS update pushed down and it the conversion lagged. Then a new update would come down and it went back to instantly again. I am now in a long period of the LONG conversions. Repairing MS Office hasn't done anything and a reinstall hasn't either.
I have done searching over the Internet and haven't found anyone experiencing this problem. Anyone have any ideas? (I put this in Excel because it is a file that comes with Excel, but if you think I should put it in the Power Tools forum, I can do that too).
Thanks!