Forum Discussion
Updating Data Source Causing Table to Disapear
I built a report that I will be updating monthly. When I select change data source for my pivot table, after adding new data to my source, it automatically clears out my whole table. All my labels are the same, and I do have some formulated columns in my data. What could cause it to do so?
1 Reply
Hello,
why would you "change the data source" when you add new data to the pivot source? If you store the source data in an Excel table object, you can point the pivot table to the table name as the data source. Then after adding new data to the table, just refresh the pivot table.
If that is not working for you, please post a sample file with dummy data and explain in context.
cheers, teylyn
