 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / March 2008Adding new data within Pivot Table
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.  SignatureTHX cs Why are you changing information in a Pivot Table instead of in the source data? --JP > 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. SignatureTHX cs > Why are you changing information in a Pivot Table instead of in the > source data? [quoted text clipped - 7 lines] > > -- > > THX cs Try disconnecting the PT from the cache, then it just becomes a static table. HTH, JP > 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 [quoted text clipped - 17 lines] > > - Show quoted text - Yes, that would work, but wouldn't it prevent any further "pivoting" (querying) by the end user? SignatureTHX cs > Try disconnecting the PT from the cache, then it just becomes a static > table. [quoted text clipped - 23 lines] > > > > - 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 > 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. > 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 [quoted text clipped - 7 lines] > > -- > > THX cs You can but the results are unpredictable, as you saw. > 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. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.