Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Keyboard remapping using pivot tables in excel 2003 on laptop | Excel Discussion (Misc queries) | |||
Pivot Tables - Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 Pivot tables - how to "show pages" | Excel Discussion (Misc queries) | |||
Pivot Tables - Using Excel 2003 & Windows XP Pro... | Excel Discussion (Misc queries) | |||
Pivot tables Excel 2003 absolute references | Excel Discussion (Misc queries) |