If the original data has changed, how do you update the data or do you need to make a new table ?
V vyhana New member Joined Nov 23, 2014 Messages 1 Reaction score 0 Points 0 Nov 23, 2014 #1 If the original data has changed, how do you update the data or do you need to make a new table ?
Bob Phillips Super Moderator Staff member Joined Mar 21, 2011 Messages 1,960 Reaction score 0 Points 36 Excel Version(s) O365 Nov 23, 2014 #2 You need to update the data. You could also make a dynamic named range and set the pivot table to look at that.
You need to update the data. You could also make a dynamic named range and set the pivot table to look at that.
T tshaikh New member Joined Nov 20, 2014 Messages 12 Reaction score 0 Points 0 Nov 24, 2014 #3 Can you tell me how to copy and paste a pivot chart to another worksbook without loosing its formatting? (And not paste as a picture), Thanks,
Can you tell me how to copy and paste a pivot chart to another worksbook without loosing its formatting? (And not paste as a picture), Thanks,