 |
 | 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 / New Users / September 2007Copying from a pivot table
I have a pivot table with data from cell B9 to cell S33. I want to add a few lines at the bottom (not as part of the pivot table), which subtract the figures in some of the rows to give a net total. I have just moved from XL2000 to XL2003, and this has caused a problem. Previously if say I wanted to subtract the figure in row 21, I could simply enter "-B21" in cell B38 and copy the formula across as far as column S. Now I can't do this because XL automatically uses the GETPIVOTDATA function, which does not adjust relatively as I copy it across. I can get what I want by first copying the whole table to another location, but surely there is a simpler way of doing this? Try Debra's page for a way to turn the "feature" off: http://www.contextures.com/xlPivot06.html  SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- >I have a pivot table with data from cell B9 to cell S33. I want to add a >few lines at the bottom (not as part of the pivot table), which subtract [quoted text clipped - 9 lines] > I can get what I want by first copying the whole table to another > location, but surely there is a simpler way of doing this? Many thanks, that seems to do it. > Try Debra's page for a way to turn the "feature" off: > http://www.contextures.com/xlPivot06.html [quoted text clipped - 12 lines] >> I can get what I want by first copying the whole table to another >> location, but surely there is a simpler way of doing this? welcome, Brian SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- > Many thanks, that seems to do it. Instead of pointing to cell -B21, try entering -B21 to complete the cell formula first, then copy it across. Ivan Hung >I have a pivot table with data from cell B9 to cell S33. I want to add a >few lines at the bottom (not as part of the pivot table), which subtract [quoted text clipped - 9 lines] > I can get what I want by first copying the whole table to another > location, but surely there is a simpler way of doing this?
|
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.