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

Hold Ctrl Key in Formula ( no typing of comma)

Hold Ctrl Key in Formula (no typing of comma) There is no need for us to select one cell then type comma (,) and again another cell and typing comma (,) and repeat it. It is easy to select required cell in formula by using keyboard Ctrl key , so that we can save a time. Example: =Sum(J3,J7,J11)
Post a Comment
Read more

Blank Cell - Color code and formatting

Blank Cell - Color code and formatting This feature is mostly used to identify blank cells and if any time some one has accidentally  deleted any value in the cell which can be identified with this trick. How to do this – Step 1 - Please click on new rule (conditional formatting) under Home tab Step 2 - Select rule type as “Format only cells that contains” Step 3 - Under edit rule section choose blanks from the drop down and click on format and select fill with color of your choice, then click on OK , again click on OK
Post a Comment
Read more

Conditional formatting - Highlight Duplicate Values

Conditional formatting - Highlight Duplicate Values This feature is mostly used to identify duplicate values in a range of cells or array, it also identify the any error of data of unique records like ID numbers, serial numbers etc . How to do this – Step 1 - First select the range of cells, then  click on Highlight cell rules (conditional formatting) under Home tab Step 2 - Select rule type as   “Duplicate Values” Step 3 - Then click on  OK
Post a Comment
Read more