 |
 | 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 / December 2005pivot chart mystery fields
I've been given the task to reverse engineer an excel pivot chart that an ex-employee created. When i look at the data source it pulls in all the fields from a particular table from an access database. However, once it gets to Step 3, and i select Layout, all of a sudden there are these extra fields that have appeared from no where! The data in these extra fields is used as grouping for the pivot chart. There is nothing in the query telling it to create extra fields, it just pulls everything from the table. When i told the chart to list all formulas (thinking they might be calculated fields) it gave me a blank list. I'm totally stumped on what to do. Can anyone help me out? Where can i go to view calculated fields (if that's what these are)? What else could these be? -keaven  Signature----------------------------------------------------------------------- Keaven Freeman chown -R us ~your/base usenet[at]keaven[dot]com ICQ: 35133457 http://www.keaven.com IM: KeavenMJ "The box said 'Requires Windows 95 or better' ... so I installed Linux" ----------------------------------------------------------------------- keaven, Try selecting a cell in the Pivot Table, then choose PivotTable / Wizard.... from the PT commandbar. Then step backward through the wizard using the "Back" button... it may show the multiple ranges or external tables that were consolidated to form the one PT. HTH, Bernie MS Excel MVP > I've been given the task to reverse engineer an excel pivot chart that an ex-employee created. > When i look at the data source it pulls in all the fields from a particular table from an access [quoted text clipped - 13 lines] > > -keaven Bernie: I have tried that :( This is where i start pulling my hair out... when i step back i find that the pivot table is connect to an single table, not a query. In step 2 of the wizard i can see all the fields being imported, they all look fine. Then, in step 3 when it sais everything is ready to go, i click on the 'layout' button and in the available fields there are extra ones that are NOT there in the field list during step 2. -keaven > keaven, > [quoted text clipped - 5 lines] > Bernie > MS Excel MVP Signature----------------------------------------------------------------------- Keaven Freeman chown -R us ~your/base usenet[at]keaven[dot]com ICQ: 35133457 http://www.keaven.com IM: KeavenMJ "The box said 'Requires Windows 95 or better' ... so I installed Linux" ----------------------------------------------------------------------- Is it possible that there are hidden columns in the data range that the pivot table is being generated from? > Bernie: > [quoted text clipped - 17 lines] >> Bernie >> MS Excel MVP Hi Keaven Try right clicking on the field that has the grouping, choose Group and see what the table has been grouped by. Are theses the "mysterious" headings that you see? Regards Roger Govier > Bernie: > [quoted text clipped - 18 lines] >> Bernie >> MS Excel MVP Roger: When I right click on the field, I select 'Group and Show Detail' then select 'Group' from the list that follows. When I do, I get an error message that reads, 'Cannot Group that selection.' -keaven > Hi Keaven > [quoted text clipped - 5 lines] > > Roger Govier Signature----------------------------------------------------------------------- Keaven Freeman chown -R us ~your/base usenet[at]keaven[dot]com ICQ: 35133457 http://www.keaven.com IM: KeavenMJ "The box said 'Requires Windows 95 or better' ... so I installed Linux" ----------------------------------------------------------------------- |
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.