Skip to main content

TIP - 38 : Get Pivot table data in regular or normal


Get Pivot table data in regular or normal


This trick will help us where we had a pivot table data which was used to link data to any cell.

We always get value of cell with “=GetPivotData” and if we use copy and paste to below range of cells, information on the cells were looks bit strange.


To avoid that situation to normalize the Pivot table data use the following trick –

Step 1: Go to File tab and click on options

Step 2: From the dialogue box Excel Options, go to Formulas section and uncheck the “Use GetPivotdata functions for PivotTable references" option, then click on OK

Now Pivot table data used for linking as normal data

Comments

Post a Comment

Popular posts from this blog

Report Publishing via Pivot Table in different sheets

Report Publishing via Pivot Table in different sheets This feature is mostly helpful to publish the data in sheet wise Step 1: Create pivot table with Report filter , go to analysis tab or Options tab from "PivotTable options" Step 2: Click on options drop down Step 3: Then click on  “Show report filter pages” Now we can see the new excel sheet tabs names along with data, published based on the report filtered data.
Post a Comment
Read more