When my Colleague opens a csv file in Excel 2000, it opens fine, when I do
the same in 2003 all contents are in the first column. We both have Dutch as
Location which I know is an issue due to the comma seperator etc. but why can
she open it?

Maybe her Windows list separator matches the separator that's used in the file?

Open up the regional settings applet under control panel

In winXP:
windows start button|settings|control panel|regional and language options
On the Regional Options tab
click the Customize button

On the numbers tab, check the list separator box. Make it match what's used in
the CSV file.

Be aware that this is a windows setting and can affect other programs.


Holmark wrote:

When my Colleague opens a csv file in Excel 2000, it opens fine, when I do
the same in 2003 all contents are in the first column. We both have Dutch as
Location which I know is an issue due to the comma seperator etc. but why can
she open it?

--

Dave Peterson

Dear Dave,

Her list seperator doesn't match the seperator in the file Her separator is
; and in the file it's , Also I've checked our settings in the regional
settings - they are all the same. - Therefore it makes no sense that it
workes with her......

"Dave Peterson" wrote:

Maybe her Windows list separator matches the separator that's used in the file?

Open up the regional settings applet under control panel

In winXP:
windows start button|settings|control panel|regional and language options
On the Regional Options tab
click the Customize button

On the numbers tab, check the list separator box. Make it match what's used in
the CSV file.

Be aware that this is a windows setting and can affect other programs.


Holmark wrote:

When my Colleague opens a csv file in Excel 2000, it opens fine, when I do
the same in 2003 all contents are in the first column. We both have Dutch as
Location which I know is an issue due to the comma seperator etc. but why can
she open it?

--

Dave Peterson

In some versions of excel (xl2002+???), there's an option you can check:

Tools|Options|International tab

Check the settings there.

Holmark wrote:

Dear Dave,

Her list seperator doesn't match the seperator in the file Her separator is
; and in the file it's , Also I've checked our settings in the regional
settings - they are all the same. - Therefore it makes no sense that it
workes with her......

"Dave Peterson" wrote:

Maybe her Windows list separator matches the separator that's used in the file?

Open up the regional settings applet under control panel

In winXP:
windows start button|settings|control panel|regional and language options
On the Regional Options tab
click the Customize button

On the numbers tab, check the list separator box. Make it match what's used in
the CSV file.

Be aware that this is a windows setting and can affect other programs.


Holmark wrote:

When my Colleague opens a csv file in Excel 2000, it opens fine, when I do
the same in 2003 all contents are in the first column. We both have Dutch as
Location which I know is an issue due to the comma seperator etc. but why can
she open it?

--

Dave Peterson


--

Dave Peterson

I've checked this in my version and it is set to use system settings but as
my colleauge runs version 2000 this option is not available.....

"Dave Peterson" wrote:

In some versions of excel (xl2002+???), there's an option you can check:

Tools|Options|International tab

Check the settings there.

Holmark wrote:

Dear Dave,

Her list seperator doesn't match the seperator in the file Her separator is
; and in the file it's , Also I've checked our settings in the regional
settings - they are all the same. - Therefore it makes no sense that it
workes with her......

"Dave Peterson" wrote:

Maybe her Windows list separator matches the separator that's used in the file?

Open up the regional settings applet under control panel

In winXP:
windows start button|settings|control panel|regional and language options
On the Regional Options tab
click the Customize button

On the numbers tab, check the list separator box. Make it match what's used in
the CSV file.

Be aware that this is a windows setting and can affect other programs.


Holmark wrote:

When my Colleague opens a csv file in Excel 2000, it opens fine, when I do
the same in 2003 all contents are in the first column. We both have Dutch as
Location which I know is an issue due to the comma seperator etc. but why can
she open it?

--

Dave Peterson


--

Dave Peterson

Although it sounds backwards to me, maybe you could try matching her settings
(sounds very silly to me, but it won't take long to test it).

And how do each of you open the file? (doubleclicking on it in windows explorer
or file|open or by a macro???).

Holmark wrote:

I've checked this in my version and it is set to use system settings but as
my colleauge runs version 2000 this option is not available.....

"Dave Peterson" wrote:

In some versions of excel (xl2002+???), there's an option you can check:

Tools|Options|International tab

Check the settings there.

Holmark wrote:

Dear Dave,

Her list seperator doesn't match the seperator in the file Her separator is
; and in the file it's , Also I've checked our settings in the regional
settings - they are all the same. - Therefore it makes no sense that it
workes with her......

"Dave Peterson" wrote:

Maybe her Windows list separator matches the separator that's used in the file?

Open up the regional settings applet under control panel

In winXP:
windows start button|settings|control panel|regional and language options
On the Regional Options tab
click the Customize button

On the numbers tab, check the list separator box. Make it match what's used in
the CSV file.

Be aware that this is a windows setting and can affect other programs.


Holmark wrote:

When my Colleague opens a csv file in Excel 2000, it opens fine, when I do
the same in 2003 all contents are in the first column. We both have Dutch as
Location which I know is an issue due to the comma seperator etc. but why can
she open it?

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson