Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / April 2008

Tip: Looking for answers? Try searching our database.

CSV file give different result when open in excel 2003 SP2 & Sp3

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Alchemist - 23 Apr 2008 10:34 GMT
Hi,

I have a CSV file which data extracted from a backend database.
I noticed this CSV file when open in excel 2003 on different machine give
different result.

The raw data  of the CSV file, the text for one particular cell consists of
a charactor ASCII (10).  

The way i open the excel file is by doing a double click on file explorer.

The different result is as below:
(1) When i open in 1 machine ( with excel 2003 SP2 installed ), the contents
of the cell displayed nicely with format in 'wrap text' .
(2) When I try on another machine (with excel 2003 Sp3 ), the text is not
wrap but it become a line break instead, making the contents after that move
to the next row.

I had been trying to trouble shoot by doing a data import wizard using
File->Open.
I leave the code page as Windows(ANSI) unchange, and delimiter as 'TAB', the
result is just like (2) , the char(10) had been treated as a line break.

Is it something to do with the different in service pack ?
Can anyone let me know how could i make the result just like in (1) in
machine 2 ?

Please help.
Alchemist - 24 Apr 2008 09:47 GMT
Hi,

We had found out the root cause.
I goto setting->Control Panel->Add Remove programs
check the "Show Updates"
and uninstall a security Patch for Excel (KB943985)  dated somewhere in
March, and reboot your machine.

Once rebooted, i double clieck on the file  no more issues.
The result show correctly as in past.

Hope this post help those who face the similiar problem.

Kind regards,
Alchemist.

> Hi,
>
[quoted text clipped - 24 lines]
>
> Please help.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.