| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Refresh not working properly
I have a Raw data sheet where I keep appending the data... When I refresh the
pivot table its not fetching the newly added rows. I checked the data range which is absolutely fine. If i create a new pivot table the newly added rows appear in it, but the existing Pivot is not pulling the data set when refreshed. Any specific reason? I am using Excel 2007. Please help. Thanks in advance. Thanks, Satish |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table Refresh not working properly
Check the Source Data of your Pivot Table whether its covering the new data
range also. Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Satish" wrote: I have a Raw data sheet where I keep appending the data... When I refresh the pivot table its not fetching the newly added rows. I checked the data range which is absolutely fine. If i create a new pivot table the newly added rows appear in it, but the existing Pivot is not pulling the data set when refreshed. Any specific reason? I am using Excel 2007. Please help. Thanks in advance. Thanks, Satish |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Subtotals do not add properly | Excel Discussion (Misc queries) | |||
| Auto Refresh of Pivot Tables not working | Excel Worksheet Functions | |||
| Create refresh button in worksheet to refresh Pivot Table Data | Excel Worksheet Functions | |||
| refresh a new worsheet on pivot table refresh | Excel Worksheet Functions | |||
| refresh option of pivot table not working | Excel Worksheet Functions | |||
Linear Mode
