#1   Report Post  
Karen
 
Posts: n/a
Default 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
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

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   Report Post  
Karen
 
Posts: n/a
Default

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   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to show data greater than 10 in pivot table Angus Excel Discussion (Misc queries) 6 September 15th 05 07:51 PM
Change Data In Pivot Table John Calder New Users to Excel 1 July 7th 05 10:41 PM
Pivot Table - show items with no data HJM Excel Discussion (Misc queries) 3 June 22nd 05 12:51 PM
Problems with Pivot Table Field Sorting in Excel 2002 Phoenix71555 Excel Discussion (Misc queries) 1 February 27th 05 11:25 PM
How to get pivot table data columns instead of rows Jessica Excel Discussion (Misc queries) 0 January 19th 05 04:29 PM


All times are GMT +1. The time now is 12:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"