Refreshing a pivot table
 

I have posted this question before but didn't get any replies so am trying
again in the hope that somebody knows the answer.....!!

When using a pivot table, is it possible to refresh only certain columns
rather than the whole table??

Any urgent help would be appreciated.

Thank you.

Louise

You can't refresh only part of a pivot table.

Perhaps you could make a copy of the source data, change only the data
you want updated in the pivot table, and base the pivot table on that.

Louise wrote:
I have posted this question before but didn't get any replies so am trying
again in the hope that somebody knows the answer.....!!

When using a pivot table, is it possible to refresh only certain columns
rather than the whole table??

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

I didn't think so but wasn't sure.

Thanks very much.

Louise.

"Debra Dalgleish" wrote:

You can't refresh only part of a pivot table.

Perhaps you could make a copy of the source data, change only the data
you want updated in the pivot table, and base the pivot table on that.

Louise wrote:
I have posted this question before but didn't get any replies so am trying
again in the hope that somebody knows the answer.....!!

When using a pivot table, is it possible to refresh only certain columns
rather than the whole table??

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html