ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2003 Pivot tables (https://www.excelbanter.com/excel-discussion-misc-queries/145365-excel-2003-pivot-tables.html)

[email protected]

Excel 2003 Pivot tables
 
I have a Hungarian Excel file (pivot table) that i am opening using
Hungarian Excel 2003,
the problem is that in the pivot table page the X-axis items are
displayed in the Y-axis
I have checked the macros (Excel 97 style macros) but there dose not
seem to be any thing wrong with them

The macros are as follows:

Makró11
=B95(TableName,"Profit SUM","Profit SUM részlete",1,2,,,,"""Ft""###
### ###0")
=PIVOT.ADD.DATA(TableName,"Sales SUM","Sales SUM részlete",
2,2,,,,"""Ft""### ### ##0,00")
=PIVOT.ADD.DATA(TableName,"Cost SUM","Cost SUM részlete",
3,2,,,,"""Ft""### ### ##0,00")
=PIVOT.FIELD.PROPERTIES(TableName,"Region",,1,0)
=PIVOT.FIELD.PROPERTIES(TableName,"Year",,3,0)
=PIVOT.FIELD.PROPERTIES(TableName,"Department",,3, 0)
=PIVOT.FIELD(TableName,"Adat",2,1)
=RETURN()

Makró9
=WORKBOOK.SELECT("Crosstab Layout 2_Base0")
=RUN("Makró10")
=SET.NAME("TableName","Kimutatás1")
=PIVOT.TABLE.WIZARD(1,"'Crosstab Layout 2_Base0'!
S1O1:S19O6","'Crosstab Layout 2'!
S1O1",TableName,FALSE,FALSE,FALSE,TRUE)
=RUN("Makró11")
=RETURN()


When i create the Excel file for English and Italian it works fine.

Is this a bug in Microsoft Excel 2003 or something wrong in the macros
that i have generated.

Any help would be appretiated.

Thanks
Arun



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com