Saved Bookmarks
| 1. |
If You Add Either New Rows Or New Columns To The Pivot Table Source Data, The Pivot Table Is Not Updated Even When You Click On 'refresh Data'. Why And What Is The Solution? |
|
Answer» This happens because the newly ADDED data is OUTSIDE the range of Pivot table's UNDERLYING data. To CURE this either provide dynamic range to the Pivot Table or manually update the pivot table's source data. This happens because the newly added data is outside the range of Pivot table's underlying data. To cure this either provide dynamic range to the Pivot Table or manually update the pivot table's source data. |
|