Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Kirk P.
 
Posts: n/a
Default Pivot Table - hide blank cells

Is there any way to suppress the display of blank cells within the data area
of a pivot table?
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Debra Dalgleish has posted code to do this:
http://groups.google.co.uk/group/mic...900b96 680905

or


http://tinyurl.com/axk75


Kirk P. wrote:

Is there any way to suppress the display of blank cells within the data area
of a pivot table?


--

Dave Peterson
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
Pivot -- want to use Max and Sum in same table Dave Excel Worksheet Functions 1 July 13th 05 04:37 AM
Using Pivot Table Function to Summarize David Excel Discussion (Misc queries) 0 July 8th 05 04:46 AM
removing the word (blank) from pivot table cells [email protected] Excel Discussion (Misc queries) 2 July 3rd 05 02:18 AM
pivot table YingRui Oliviero Excel Discussion (Misc queries) 1 April 12th 05 12:57 PM
Pivot Table Row Cell (Blank) Santhosh Mani Excel Worksheet Functions 1 April 11th 05 01:02 PM


All times are GMT +1. The time now is 02:27 PM.

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"