Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Pivottable layout through VBScript
Hi,
I have an html file that includes a vbscript for connecting to a .cub data source and adds pivot table fileds to the page. The script works fine and I can see the pivot table there. The only problem is that I want the dimensions (fliters) to be listed vertically not horizontally. In other words I would like to change the cube's layout. Could anybody tell me how I can do that. I would really appreciate any help, Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Pivottable layout through VBScript
Thanks for the reply. I tried what you suggested, but it didn't work. The layout is still the same. -----Original Message----- This is one case where using the macro recorder and examining the recorded code will help a lot. "Sahi" wrote: Hi, I have an html file that includes a vbscript for connecting to a .cub data source and adds pivot table fileds to the page. The script works fine and I can see the pivot table there. The only problem is that I want the dimensions (fliters) to be listed vertically not horizontally. In other words I would like to change the cube's layout. Could anybody tell me how I can do that. I would really appreciate any help, Thanks. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
classic pivottable layout | New Users to Excel | |||
Layout change | Setting up and Configuration of Excel | |||
Default PivotTable Layout | Excel Worksheet Functions | |||
Help with layout change | Excel Worksheet Functions | |||
Save the layout of PivotTable | Excel Programming |