LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22
Default Show items with no data on rows

Using Excel 2007 and have the need to show all items regardless of whether
there is data on the row. I have been successful in the past using the PT
Options under display to check the box that provides this capability.
However, I have a new PT and in trying to implement this, the option is
grayed out and cannot be checked. What conditions in Excel/PT or data may
cause this option to not be available.

Thanks,

J Austin
 
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
Show only relevant no-data items in pivot table Workforce_info_Kings_NHS Excel Discussion (Misc queries) 1 January 19th 11 06:59 PM
Show Pivot Table Items That Have No Data J Austin Excel Discussion (Misc queries) 0 October 12th 08 05:30 PM
OLAP Pivot table - How to show items with no data ? Timmo Excel Worksheet Functions 1 March 30th 06 06:03 PM
show items with no data option in pivot tables AHuntington Excel Discussion (Misc queries) 2 August 23rd 05 01:30 PM
Pivot Table - show items with no data HJM Excel Discussion (Misc queries) 3 June 22nd 05 12:51 PM


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

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"