Thread
:
Pivot Table - Changing Data....?
View Single Post
#
4
Posted to microsoft.public.excel.misc
prakash
external usenet poster
Posts: 4
Pivot Table - Changing Data....?
Hi all,
is there any way to aumatically pivot table get refresh when the data
has a change in sheet 2 using vba
thanks in advance ,
prkn.
Debra Dalgleish wrote:
You need to change the data on sheet 2. If you make a change in the
pivot table, it won't affect the source data.
wrote:
I have my pivot table on sheet 1 and my data on sheet 2 in my
spreadsheet.
The data is quite large so if i wanted to look something up and change
it i thought i could use the pivot table to do this but it doesnt
change the data on sheet 2. Is this possible of would you need to
change the data on sheet 2 instead.
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html
Reply With Quote
prakash
View Public Profile
Find all posts by prakash