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
>
>