Weekly Dynamic: Excel Pivot Tables, Clear Old Items

This week’s tip is great for dashboards and come via Zubin Gidwani of Dynamics Budgets. When your refresh or change your pivot table’s source data, Excel can sometimes retain old pivot table selections that no longer exist. These phantom selections can confusing to users. There are a couple of things to look at here. For […]

The post Weekly Dynamic: Excel Pivot Tables, Clear Old Items appeared first on DynamicAccounting.net.