Pivot Tables 2010

[MikeyZ]

Novice here ...

I created a PT with 100 lines.
the next day it may have 200 lines.
If I hit REFRESH it doesn't look at the 200 lines .

What am I doing wrong?
I don't have to create a whole new PT do I?

 

[blbat]

Change the data source to include the new lines.
(PivotTable Tools | Options tab | Change Data Source)

edit: be sure to "Refresh All" after changing the Source.

 

[MikeyZ]

Clicked on the Data Source | Selected the additional Data (Ctrl+END basically reselecting the entire data table .
When I click ok I get an error msg saying that the PT field name is invalid.
???????

 

[MikeyZ]

Figured it out.
I had changed some of the Column header names and it didn't like that..
REran the PT and tried testing changing it etc.
Worked fine..