View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcotte A
 
Posts: n/a
Default Select all subtotal rows on Pivot Table

Thanks Ron. I did that on my machine and it now reproduces my supervisors
problem. Enabling Selection then solved the problem. Thanks.

Marcotte

"Ron Coderre" wrote:

Try this:

Right-click on the Pivot Table
Select "Select" from the shortcut menu
Select: Enable Selection

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro