LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default PivotTable Columns


Is there anyway to order the columns that appear in a PivotTable?

At present, I am not building the PivotTable with code, and the column
order appears to be determined by the order in which different values
are arrived at as the table is built, moving down the Excel list. I
would like to control the order in which my columns.

Does this require code and if so could anyone give me some clues on what
object to reasearch.

Paul Smith


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 
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
PivotTable Sum 2 Columns Mouimet Excel Worksheet Functions 1 November 20th 09 12:55 AM
How do I get PivotTable data results to show in columns instead ro GeorgeK@Novagard Excel Discussion (Misc queries) 4 April 23rd 08 06:36 PM
Show % between two columns in a pivottable dq Excel Worksheet Functions 2 May 7th 07 06:46 PM
PivotTable Columns Dominique Feteau Excel Programming 1 June 26th 04 01:45 AM
PivotTable columns not going Invisible Stoney Excel Programming 0 November 5th 03 10:26 PM


All times are GMT +1. The time now is 06:03 AM.

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

About Us

"It's about Microsoft Excel"