Data not automatically Refresh

[ramco1917]

Hi

I have created table and then Pivot table. I removed some data fromTable . Pivot didn't automatically refreshed. I have to click on Refresh in Pivot Table
Should Pivot table does not automatically gets refreshed. Similarly Slicer also didn't get refreshed automatically.

Thanks

 

[shift-del]

Hi

That is the standard behaviour in Excel. If you want instant calculation then use formulas.