Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Arland Smith   on Sep 16 In MS Office Category.

  
Question Answered By: Madeeha Malik   on Sep 16

One solution I use is:
Hide the actual sheet that contains the pivot  table.
In another (new) worksheet, have a 'copy' of the pivot table. This 'copy' can be
created by selecting (1st unhiding the original) & copying the actual Pivot
table; then on the 'other' worksheet, paste special 'formats' & 'values' (then
re-hide the original).
The 'format/value' copy of the Pivot table  has no pivot control!

A macro can be created  to automate the sequence of events.

Share: 

 
 
Didn't find what you were looking for? Find more on Disable Pivot Toolbar Or get search suggestion and latest updates.


Tagged: