Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
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
Posted to microsoft.public.excel.setup
|
|||
|
|||
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
Posted to microsoft.public.excel.setup
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
problem in attaching files( Pivot Tables ) | Excel Discussion (Misc queries) | |||
Pivot tables, stupid problem | Excel Discussion (Misc queries) | |||
Please help: Pivot Tables problem | Excel Discussion (Misc queries) | |||
Pivot tables, problem with grouping the date column | Excel Discussion (Misc queries) | |||
Problem with times in pivot tables and graphs | Excel Discussion (Misc queries) |