Disabling Pivot Table Interface

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.
 
K

Khawar

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

Best Regards
Khawar
 
T

Tushar Mehta

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
 
M

Marauderz

That's a good suggestion.. except the option is greyed out.

=P

Any other suggestions?
 
M

Marauderz

Oh... let me guess.. doesn't work when I'm using a Cube from an Analysis
Server right?
 
T

Tushar Mehta

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
 

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

Doughnut Chart linked with the slicer in the pivot table 0
Dealing with a Pivot Table (when I don't want to) 0
pivot 0
Sharepoint not capturing staff name when automation runs 0
Expanding Single Items In Large Pivot Tables 1
Excel does not accept text format! 0
Excel 2007 pivot table using analysis services cube as data source 0
SUM & OFFSET & PIVOT TABLE?? 0

Top