Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
EJO
 
Posts: n/a
Default Make Excel opnening CSV files work properly again.

By company standard, I'm using an US edition of Windows XP pro. (sp2 all
patches installed.) and Office 2003 SP1, again us edition. I work in holland
so I would prefer using the dutch regional settings in my control panel.

What frustates me:
When I'm using US Regional settings in control panel, changing list
seperator actually works and influences the way Excel opens CVS files.
When i'm Dutch regional settings, changing the list seperator char does not
influence the way Excel opnens CVS files, in effect we can't work with csv
files at all.

Please correct this as soon as you can, or provide some feedback to users
like me that can not explain this.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc
  #2   Report Post  
Damon Longworth
 
Posts: n/a
Default

A workaround is to rename the file with a TXT extension. This will force the
input wizard to open and you will be able to define the delimiter.

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com


"EJO" wrote in message
...
By company standard, I'm using an US edition of Windows XP pro. (sp2 all
patches installed.) and Office 2003 SP1, again us edition. I work in
holland
so I would prefer using the dutch regional settings in my control panel.

What frustates me:
When I'm using US Regional settings in control panel, changing list
seperator actually works and influences the way Excel opens CVS files.
When i'm Dutch regional settings, changing the list seperator char does
not
influence the way Excel opnens CVS files, in effect we can't work with csv
files at all.

Please correct this as soon as you can, or provide some feedback to users
like me that can not explain this.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc



  #3   Report Post  
Janski
 
Posts: n/a
Default

In my company we have the same standard and exactly the same problem. We use
Finnish regional settings, US edition of Windows XP pro (sp2 and all patches
installed), Excel 2000 with sr-1. When we download csv file from Internet
Explorer all data will be in the same column in Excel.

We have also computers with only Windows XP Pro SP1 installed. In those
machines csv files open correctly.

This is really annoying.

If I go to Regional settings and change settings to US everything works. If
I put both decimal and list separator to comma (which is the usual setup in
Finland) the problem re-occurs.

If I first save the csv file to hard drive and open it from there using
explorer it opens correctly. So I would assume that the problem occurs when
csv file is opened over internet explorer.

I hope that Microsoft would correct this problem as soon as possible.

The workaround to save first to txt file is not suitable for us.



"EJO" wrote:

By company standard, I'm using an US edition of Windows XP pro. (sp2 all
patches installed.) and Office 2003 SP1, again us edition. I work in holland
so I would prefer using the dutch regional settings in my control panel.

What frustates me:
When I'm using US Regional settings in control panel, changing list
seperator actually works and influences the way Excel opens CVS files.
When i'm Dutch regional settings, changing the list seperator char does not
influence the way Excel opnens CVS files, in effect we can't work with csv
files at all.

Please correct this as soon as you can, or provide some feedback to users
like me that can not explain this.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

  #4   Report Post  
Posted to microsoft.public.excel.misc
jasper
 
Posts: n/a
Default Make Excel opnening CSV files work properly again.

We have excact same problem, only solution is for Microsoft to correct this
in excel.
Problem we face: our client generates CSV files, and uses the seperator
defined in the regional settings. If users with dutch language setings,
changethe default seperator, they wil not be able to open our files in excel.

"EJO" wrote:

By company standard, I'm using an US edition of Windows XP pro. (sp2 all
patches installed.) and Office 2003 SP1, again us edition. I work in holland
so I would prefer using the dutch regional settings in my control panel.

What frustates me:
When I'm using US Regional settings in control panel, changing list
seperator actually works and influences the way Excel opens CVS files.
When i'm Dutch regional settings, changing the list seperator char does not
influence the way Excel opnens CVS files, in effect we can't work with csv
files at all.

Please correct this as soon as you can, or provide some feedback to users
like me that can not explain this.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Make Exec work properly (error messages on start and exit) TorG 8-(( Excel Discussion (Misc queries) 9 April 18th 06 01:10 PM
make excel files executable Horatio J. Bilge Excel Discussion (Misc queries) 4 June 28th 05 02:49 PM
Excel 2003 crashes loading excel files created Excel 2000 Jeff Lewin Australia Excel Discussion (Misc queries) 0 June 27th 05 04:20 AM
Making files with excel Mike C Excel Worksheet Functions 1 March 18th 05 06:15 PM
How do I update Excel 2000 macros to work in Excel 2002? BobPetrich Excel Discussion (Misc queries) 3 January 4th 05 04:06 PM


All times are GMT +1. The time now is 08:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"