Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default 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

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
Keyboard remapping using pivot tables in excel 2003 on laptop anitadai Excel Discussion (Misc queries) 1 January 12th 07 08:35 AM
Pivot Tables - Excel 2003 oceanmist Excel Discussion (Misc queries) 1 August 25th 06 04:42 PM
Excel 2003 Pivot tables - how to "show pages" RosH Excel Discussion (Misc queries) 1 August 9th 05 01:17 PM
Pivot Tables - Using Excel 2003 & Windows XP Pro... Birmangirl Excel Discussion (Misc queries) 1 June 8th 05 01:32 AM
Pivot tables Excel 2003 absolute references Poj Excel Discussion (Misc queries) 2 January 25th 05 12:57 PM


All times are GMT +1. The time now is 11:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"