Logo
DiS Needs You: Save our site »
  • Logo_home2
  • Records
  • In Depth
  • In Photos
  • Blog
  • Podcast
  • Search
  • Community
  • Records
  • In Depth
  • Blog
  • Community

THIS SITE HAS BEEN ARCHIVED AND CLOSED.

Please join the conversation over on our new forums »

If you really want to read this, try using The Internet Archive.

Boards

Music Social More…

Excel help pls!

mattty [Edit] [Delete] 14:17, 22 January '09

Problem: I add a data field to a pivot table, but subsequently can't remove it

Code to add data field:
PivotTables(1).AddDataField PivotTables(1).PivotFields("Revenue"), "Sum of Revenue", xlSum

Code to hide it:
PivotTables(1).PivotFields("Sum of Revenue").orientation = xlHidden

Any ideas? This honestly seems to be a bug to me. Haven't been able to find anything on t'web.

Running Excel 2007 on Windows XP


Drowned in Sound
  • DROWNED IN SOUND
  • HOME
  • SITE MAP
  • NEWS
  • IN DEPTH
  • IN PHOTOS
  • RECORDS
  • RECOMMENDED RECORDS
  • ALBUMS OF THE YEAR
  • FESTIVAL COVERAGE
  • COMMUNITY
  • MUSIC FORUM
  • SOCIAL BOARD
  • REPORT ERRORS
  • CONTACT US
  • JOIN OUR MAILING LIST
  • FOLLOW DiS
  • GOOGLE+
  • FACEBOOK
  • TWITTER
  • SHUFFLER
  • TUMBLR
  • YOUTUBE
  • RSS FEED
  • RSS EMAIL SUBSCRIBE
  • MISC
  • TERM OF USE
  • PRIVACY
  • ADVERTISING
  • OUR WIKIPEDIA
© 2000-2025 DROWNED IN SOUND