ExcelBanter - Excel 2003 will not open CSVs parsed out.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel 2003 will not open CSVs parsed out. (https://www.excelbanter.com/excel-discussion-misc-queries/191024-excel-2003-will-not-open-csvs-parsed-out.html)

Trolane

Excel 2003 will not open CSVs parsed out.

Excel 2007 works fine.
The CSVs worked in excel 2003 4 months ago.
The regional settings on the computers are set to use , as the list delimeter.

What can be done to make excel 2003 wake up and open the CSVs and parse them
instead of it all being 1 column?

Kevin B

Excel 2003 will not open CSVs parsed out.

If you open Excel and then use File/Open to get the CSV file the wizard will
automatically update

Kevin Backmann

"Trolane" wrote:

Excel 2007 works fine.
The CSVs worked in excel 2003 4 months ago.
The regional settings on the computers are set to use , as the list delimeter.

What can be done to make excel 2003 wake up and open the CSVs and parse them
instead of it all being 1 column?

Trolane

Excel 2003 will not open CSVs parsed out.

but it should open without using a wizard since its a CSV.

"Kevin B" wrote:

If you open Excel and then use File/Open to get the CSV file the wizard will
automatically update

Kevin Backmann

"Trolane" wrote:

Excel 2007 works fine.
The CSVs worked in excel 2003 4 months ago.
The regional settings on the computers are set to use , as the list delimeter.

What can be done to make excel 2003 wake up and open the CSVs and parse them
instead of it all being 1 column?

All times are GMT +1. The time now is 04:01 PM.