Excel Tip – Detach a pivot desk from its information supply

Excel Tip – Detach a pivot desk from its information supply

Excel Tip – Detach a pivot desk from its information supply

Pivot tables are undoubtedly among the finest options of Microsoft Excel, nevertheless splitting them up can grow to be fairly tough as your file dimension will get greater, so it is not all the time attainable to ship the file with out decompressing it, despatched via a switch program.

Chances are you’ll not all the time wish to share your supply information as probably confidential. To share abstract information, you will must in some way decouple your Pivot from its information supply. Sadly Excel would not have a break characteristic, but it surely’s attainable to attain the identical consequence with a couple of additional steps.

So in case you have a Pivot that you’ve got formatted and also you’re pleased with the format and degree of research, we will use the actually versatile Paste Particular command together with the Worth command.

1. First choose the cells of the principle desk and press CTRL+C to repeat the vary or you should use the Ribbon command by choosing any cell in your desk after which

  • On the Pivot Desk- Choice Choices tab
  • Within the Actions group – Click on Choose
  • Choose All Pivot

If this feature just isn’t out there, you have to to allow the Allow Choice possibility.

  • Choose a cell within the desk
  • On the Pivot Desk- Choice Choices tab
  • Within the Actions group – Click on Choose
  • Examine if Activation is ON or Off, be sure that it’s ON

2. As soon as the desk is chosen, the Paste Particular dialog field seems. Urgent Alt+ES is a shortcut and works for all variations of Excel

3. Within the Paste Particular dialog field, choose the Values ​​possibility and click on OK.

The pivot desk is now indifferent, however should you’re utilizing Excel 2007 or Excel 2010, the pivot desk model formatting is gone, and we have to get this again—which we will do with two extra additional steps.

4. Show the Workplace Clipboard. In Excel 2007 and 2010, click on the dialog field launcher icon within the decrease proper nook of the Dwelling – Clipboard group

5. With the unrelated pivot chosen, click on the merchandise on the Workplace Clipboard that corresponds to the principle clipboard copy operate. It is going to be the final merchandise, except you copied one thing else after the final motion you carried out.

Now the principle desk just isn’t sure to its information supply, but retains all of its unique formatting. Now you possibly can simply share abstract information that has the appear and feel of the unique information with not one of the hassles related to information sources and file dimension.


#Excel #Tip #Detach #pivot #desk #information #supply

Leave a Comment

Your email address will not be published.

Scroll to Top