Monthly I create reports based on Pivot Tables.
I have a sheet where I update the Pivot Table data and then I just refresh the tables to update the numbers. I delete the old data and replace it with new data.
The problem is that when I click on the drop down box to drill now on information. The Old data appears and not the new one. Even though the old data has been deleted????
Does anyone know how to get around this?
Thanks
I have a sheet where I update the Pivot Table data and then I just refresh the tables to update the numbers. I delete the old data and replace it with new data.
The problem is that when I click on the drop down box to drill now on information. The Old data appears and not the new one. Even though the old data has been deleted????
Does anyone know how to get around this?
Thanks