Problem: Rebuild Pivot with every Data Update

Hi, I'm not exactly the best excel user. Recently been tasked to do some data crunching.

I'm using a very basic 2 worksheet. 1 for my data (new rows for every new data) and 1 for my Pivot Table.
The problem I've been facing is that with every new input, I would update my Pivot Tables by using "Change Data Source" ( CTR + A). But every time I update the pivot table, the table that I built refreshes and I have to pick the info I want again(basically the table resets)

Is there anyway to go about doing this?

Thank you so so much!!!

tiptop,

Try converting your data into a proper excel table. Once you create your PT and add new data, all you need to do is refresh, no messing around with "Change Data Source". Hope this helps.

Originally Posted by Flyboy65

tiptop,

Try converting your data into a proper excel table. Once you create your PT and add new data, all you need to do is refresh, no messing around with "Change Data Source". Hope this helps.

Hi, I'm sorry but how exactly do you go about "converting data into a proper excel table?"

Thank you so so much!

Try looking at this video and see if it answers you questions.
http://www.contextures.com/xlExcelTable01.html#What