Is it possible to add or change information within a Pivot table and have it
stay with that record? Right now it appears to be replacing all the data in
the column when I enter the new information for the cell within the pivot
grid.
--
THX cs

Why are you changing information in a Pivot Table instead of in the
source data?

--JP

On Mar 19, 12:20*pm, Cydney wrote:
Is it possible to add or change information within a Pivot table and have it
stay with that record? Right now it appears to be replacing all the data in
the column when I enter the new information for the cell within the pivot
grid.
--
THX cs

Simply because it's an easier format for the end user to add/change data.
They've applied their query criteria to select their own clients and want to
update one or two fields without having to find the data in the thousands of
rows in the raw table (data source) --which actually is external to the
spreadsheet anyway.
--
THX cs


"JP" wrote:

Why are you changing information in a Pivot Table instead of in the
source data?

--JP

On Mar 19, 12:20 pm, Cydney wrote:
Is it possible to add or change information within a Pivot table and have it
stay with that record? Right now it appears to be replacing all the data in
the column when I enter the new information for the cell within the pivot
grid.
--
THX cs

Try disconnecting the PT from the cache, then it just becomes a static
table.


HTH,
JP

On Mar 19, 1:08*pm, Cydney wrote:
Simply because it's an easier format for the end user to add/change data.
They've applied their query criteria to select their own clients and want to
update one or two fields without having to find the data in the thousands of
rows in the raw table (data source) --which actually is external to the
spreadsheet anyway.
--
THX cs



"JP" wrote:
Why are you changing information in a Pivot Table instead of in the
source data?

--JP

On Mar 19, 12:20 pm, Cydney wrote:
Is it possible to add or change information within a Pivot table and have it
stay with that record? Right now it appears to be replacing all the data in
the column when I enter the new information for the cell within the pivot
grid.
--
THX cs- Hide quoted text -

- Show quoted text -

Yes, that would work, but wouldn't it prevent any further "pivoting"
(querying) by the end user?
--
THX cs


"JP" wrote:

Try disconnecting the PT from the cache, then it just becomes a static
table.


HTH,
JP

On Mar 19, 1:08 pm, Cydney wrote:
Simply because it's an easier format for the end user to add/change data.
They've applied their query criteria to select their own clients and want to
update one or two fields without having to find the data in the thousands of
rows in the raw table (data source) --which actually is external to the
spreadsheet anyway.
--
THX cs



"JP" wrote:
Why are you changing information in a Pivot Table instead of in the
source data?

--JP

On Mar 19, 12:20 pm, Cydney wrote:
Is it possible to add or change information within a Pivot table and have it
stay with that record? Right now it appears to be replacing all the data in
the column when I enter the new information for the cell within the pivot
grid.
--
THX cs- Hide quoted text -

- Show quoted text -

Actually no, I mistyped, you could just copy and paste the Pivot Table
to a new range to get a "static" table. Then you could use the
original for querying and the copy can be edited as you please.

HTH,
JP


On Mar 19, 1:25*pm, Cydney wrote:
Yes, that would work, but wouldn't it prevent any further "pivoting"
(querying) by the end user?
--
THX cs

OK. I guess that means "No, you can not enter information into a LIVE Pivot
table", but by copying it to a new sheet, you can work with the static
version.

Thanks for the help.

"JP" wrote:

Actually no, I mistyped, you could just copy and paste the Pivot Table
to a new range to get a "static" table. Then you could use the
original for querying and the copy can be edited as you please.

HTH,
JP


On Mar 19, 1:25 pm, Cydney wrote:
Yes, that would work, but wouldn't it prevent any further "pivoting"
(querying) by the end user?
--
THX cs

You can but the results are unpredictable, as you saw.

On Mar 19, 2:17*pm, Cydney wrote:
OK. I guess that means "No, you can not enter information into a LIVE Pivot
table", but by copying it to a new sheet, you can work with the static
version.

Thanks for the help.