Latest MS Update KB943985 Breaks Excel CSV Capabilities

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

arsen@emergency24.com - 14 Mar 2008 16:43 GMT

Hi,

After I installed KB943985 (the one released on March 11th, 2008), my
Excel stopped properly opening CSV files. Prior to installation of
this update, Excel 2003 was opening the files properly and
automatically splitting them into columns.

After I installed the update, when opening the exact same CSV file,
all the data would appear in the first column (A).

I went ahead and uninstalled the update. Now, I am able to open the
same CSV file again without problems - it gets split into columns and
everything looks good.

Did anyone else encounter the same issue? Is MS going to fix it?

Thanks,
Arsen

Reply to this Message

av613 - 14 Mar 2008 17:08 GMT

Hi,

I just did some more research on this and see that the problem with
opening the CSV files happens ONLY when that file is saved in Unicode
or UTF-8 format. If I open the .csv file with Notepad and Save it As
"ANSI", the Excel with the latest update opens it properly.

Is this on purpose or is this a mistake? Shouldn't Excel open the
UTF-8 formatted CSV file just fine?

Thanks,
Av

Reply to this Message

Rate this thread: