You need to change the data on sheet 2. If you make a change in the
pivot table, it won't affect the source data.

wrote:

I have my pivot table on sheet 1 and my data on sheet 2 in my
spreadsheet.

The data is quite large so if i wanted to look something up and change
it i thought i could use the pivot table to do this but it doesnt
change the data on sheet 2. Is this possible of would you need to
change the data on sheet 2 instead.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html