Hi guys...this might be a silly question....

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.

Thanks

Brian

I've found that, from-time-to-time and for no apparent reason, a Pivot Table
will go 'out of sync' with reality. The easiest way of resolving this is to
set up the Pivot Table again.

Regards.

Bill Ridgeway
Computer Solutions

wrote in message
ps.com...
Hi guys...this might be a silly question....

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.

Thanks

Brian

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

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

You can use event programming to refresh the pivot table when the data
is changed or to refresh the pivot table when its worksheet is selected
(if it's on a different sheet than the data).

For example, with the pivot table on its own sheet, right-click that
sheet's sheet tab.
Choose View Code
Paste the following code where the cursor is flashing:

'==============
Private Sub Worksheet_Activate()
Dim pt As PivotTable
For Each pt In ActiveSheet.PivotTables
pt.PivotCache.Refresh
Next pt
'===================

Close the Visual Basic Editor and return to Excel
Update the data, then select the pivot table sheet, to see that it's
automatically updated.

prakash wrote:
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




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html