Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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 |
#2
![]() |
|||
|
|||
![]()
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 |
#3
![]() |
|||
|
|||
![]()
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 |
#4
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to show data greater than 10 in pivot table | Excel Discussion (Misc queries) | |||
Change Data In Pivot Table | New Users to Excel | |||
Pivot Table - show items with no data | Excel Discussion (Misc queries) | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) | |||
How to get pivot table data columns instead of rows | Excel Discussion (Misc queries) |