Hide empty rows in pivot table Excel 2003

  • Thread starter Thread starter menda
  • Start date Start date
M

menda

Hi,

I have a problem displaying pivot tables in Excel 2003. I would like blank
rows to be hidden, but I don't find any options for this. In Excel 2007 I
found it at the pivot tables options and in owc pivot table I found it under
commands and options.

Does anyone know an option in Excel 2003?

Thanks for the help.

L.M.
 
Hi,

Thanks for the help! Unfortunately in my case this option is inactive. Could
someone tell me why? I use an external data source, and I've tried it with a
cube on SQL Server 2005 and on SAS olap server as well, neither worked.

Regards,
L.M.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Question on the occupied field of the pivot table in excel spreadsheet 0
Display No Data in Pivot 1
Pivot table filter list - listing irrelevant subcategorys 1
pivot table source data expand to new entries when refresh? 4
Pivot using 250,000 rows of data in Excel? 1
Hiding Zero Values in a Pivot Table - MS Excel 2007 4
how do I get a top 25 on a pivot table in excel 2007 1
Pivot Chart - Excel 2013 - Rotating Second and Third Lines of text onthe Horizontal Axis 0

Back
Top