Hi:

If you add data into the source data of the pivot.

Right click on the pivot table and say refresh.

If you added an extra column or row you need to ensure that that data is
covered in the selection.

Do this by right clicking over the pivot table and select PivotTable Wizard
and then click the back button on the dialog and change the selection to
include the new row.

Then select 'Finish'.

Voila!
--
Hope this helps
Martin Fishlock, www.nyfconsultants.com, Wolverhampton, UK
Please do not forget to rate this reply.


"Anna" wrote:

Hi - I have never used pivot tables in Excel before so hopefully what I am
going to ask is possible and not too complicated for me.... :o)

I am working with Excel 2003. I have a pivot table already set up and the
information is pulling data from a row titled "sum of Subscriber". I added
new data in a new column from the main spreadsheet and I would like to pull
the data from there. Its titled "Adj Subscriber".

Is it possible to switch it? If so, how?

Thanks, Anna Marie