Disabling Pivot Table Interface

  • Thread starter Thread starter Marauderz
  • Start date Start date
M

Marauderz

Hi guys and gals,

Can someone tell me how I can go about to creating a normal table from a
pivot table, so a person can no longer drill down or drill up?

Thanks.
 
Highlight the whole pivot table.
Then Press
Ctrl+C (Copy)=>
Paste Special => Values

Best Regards
Khawar
 
Right-click inside the table then select Table Options...

In the dialog box, towards the bottom, in the Data Options section, for
the Data Source options uncheck the 'Enable drill to details' option.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Oh... let me guess.. doesn't work when I'm using a Cube from an Analysis
Server right?
 
But a PT based on a OLAP cube doesn't support drill down capability in
the first place. So, disabling drilldown is a non-issue.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top