Pivot Table Data
 

I've just discovered pivot tables and WOW!

A **totally** beginner question: It appears that changes made to the source
data will reflect in a pivot table, after refreshing. But, vice-versa, it
appears that changes made in a pivot table cannot be reflected in the source
data. Am I correct?

Many thanks,

Karen

That's correct -- if you change a heading in the pivot table, it doesn't
affect the source data.

There's a sample file on my web site that uses programming to change
source data, after a change in the pivot table. Make a backup copy of
the data before experimenting:

http://www.contextures.com/excelfiles.html

Under pivot tables, look for 'Change Pivot Source Data'

Karen wrote:
I've just discovered pivot tables and WOW!

A **totally** beginner question: It appears that changes made to the source
data will reflect in a pivot table, after refreshing. But, vice-versa, it
appears that changes made in a pivot table cannot be reflected in the source
data. Am I correct?

Many thanks,

Karen


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

Thanks, Debra. I've looked the page you referred me to...which topic
addresses this situation?

"Debra Dalgleish" wrote:

That's correct -- if you change a heading in the pivot table, it doesn't
affect the source data.

There's a sample file on my web site that uses programming to change
source data, after a change in the pivot table. Make a backup copy of
the data before experimenting:

http://www.contextures.com/excelfiles.html

Under pivot tables, look for 'Change Pivot Source Data'

Karen wrote:
I've just discovered pivot tables and WOW!

A **totally** beginner question: It appears that changes made to the source
data will reflect in a pivot table, after refreshing. But, vice-versa, it
appears that changes made in a pivot table cannot be reflected in the source
data. Am I correct?

Many thanks,

Karen


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

Under pivot tables, look for 'Change Pivot Source Data'

Karen wrote:
Thanks, Debra. I've looked the page you referred me to...which topic
addresses this situation?

"Debra Dalgleish" wrote:


That's correct -- if you change a heading in the pivot table, it doesn't
affect the source data.

There's a sample file on my web site that uses programming to change
source data, after a change in the pivot table. Make a backup copy of
the data before experimenting:

http://www.contextures.com/excelfiles.html

Under pivot tables, look for 'Change Pivot Source Data'

Karen wrote:

I've just discovered pivot tables and WOW!

A **totally** beginner question: It appears that changes made to the source
data will reflect in a pivot table, after refreshing. But, vice-versa, it
appears that changes made in a pivot table cannot be reflected in the source
data. Am I correct?

Many thanks,

Karen


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





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