Refresh Data erases my rows!

[paindivine]

So I built a pivot table and chart based on the following sort of data:

Please Login or Register  to view this content.

I actually have every month in my chart. When I try to make a pivot table it shows me the following fields to chose from:
Salesman
jan
feb
mar
apr

Which is odd.... I take it Pivot tables don't like arrays? Anyway, I was able to get it to look like what I wanted by putting "Salesman" in the "Page" field. Then draggin all the months one at a time to row section and setting them to "sum" Then the pivot line chart comes out looking nice. I can switch between salesman in the drop down and see different graphs. The problem is that when I change the data and click "Refresh Data" ALL of the months get removed form the pivot table and chart.

Is there any way arround this?
Thanks!

[VBA Noob]

Hi,

This link might help
http://www.contextures.com/xlfaqPivot.html#FormatLost

VBA Noob

[paindivine]

Thanks, I tried all those suggestions but they didn't help. :-(

[VBA Noob]

Are you using a dymanic range or reselecting the new data.

Try making it dymanic to see if that solves the issue

http://www.contextures.com/xlPivot01.html

VBA Noob

[paindivine]

Oh wait, it did work! I had to enable the options you suggested with that link and then re-build the table. Just selecting the options and saving it wasn't enough.

Sweet, you rock!

[VBA Noob]

Glad it helped

VBA Noob