Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 2
Default Localisation problem with pivot tables

Hello,

I have a really annoying problem:
When adding a pivot table via PivotTables.Add I have to specify the
destination in the row/column notation, e.g. R3C1.
This works on english installations but not on german ones. There I have to
use Z3S1!!
I am using C# to automate Excel.
Before calling any Excel method I set the thread locale to en-US as
described he http://support.microsoft.com/kb/320369/en-us
But still, the problem occurs on german installations.
This is a major issue for me and urgent, too.

Please advise!

Thanks in advance,

Daniel
  #2   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 35,218
Default Localisation problem with pivot tables

Why not use the address? That parm is pretty forgiving. If I remember
correctly, it'll take a range variable, or an address (A1 reference style) or an
address (r1c1 reference style).



Daniel Hilgarth wrote:

Hello,

I have a really annoying problem:
When adding a pivot table via PivotTables.Add I have to specify the
destination in the row/column notation, e.g. R3C1.
This works on english installations but not on german ones. There I have to
use Z3S1!!
I am using C# to automate Excel.
Before calling any Excel method I set the thread locale to en-US as
described he http://support.microsoft.com/kb/320369/en-us
But still, the problem occurs on german installations.
This is a major issue for me and urgent, too.

Please advise!

Thanks in advance,

Daniel


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 2
Default Localisation problem with pivot tables

That worked! Thanks A LOT for that hint!

"Dave Peterson" wrote:

Why not use the address? That parm is pretty forgiving. If I remember
correctly, it'll take a range variable, or an address (A1 reference style) or an
address (r1c1 reference style).



Daniel Hilgarth wrote:

Hello,

I have a really annoying problem:
When adding a pivot table via PivotTables.Add I have to specify the
destination in the row/column notation, e.g. R3C1.
This works on english installations but not on german ones. There I have to
use Z3S1!!
I am using C# to automate Excel.
Before calling any Excel method I set the thread locale to en-US as
described he http://support.microsoft.com/kb/320369/en-us
But still, the problem occurs on german installations.
This is a major issue for me and urgent, too.

Please advise!

Thanks in advance,

Daniel


--

Dave Peterson

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
problem in attaching files( Pivot Tables ) Rajesh Chandra Excel Discussion (Misc queries) 1 January 19th 08 09:35 PM
Pivot tables, stupid problem evaluaciondeproyectos08 Excel Discussion (Misc queries) 3 February 8th 07 04:35 PM
Please help: Pivot Tables problem James Yeang Excel Discussion (Misc queries) 5 April 25th 06 01:45 AM
Pivot tables, problem with grouping the date column kuvulmaz Excel Discussion (Misc queries) 8 February 13th 06 01:33 PM
Problem with times in pivot tables and graphs [email protected] Excel Discussion (Misc queries) 2 February 23rd 05 07:59 AM


All times are GMT +1. The time now is 02:51 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"