Prev: Using Popups to supply variables
Next: CAN A VALUE BE RETURNED WHEN TEXT IS ENTERED IN A DIFFERANT CELL?
From: PaEyer on 31 Jan 2010 14:05 When I try to update a pivot table (created in Excel 97, later updated in Excel 2003) in Excel 2007, some of the fields from the source database are not available. (Plus it offers fields from other sheets in the workbook, but that's another issue.) It's the same when I try to create a new pivot table - all the fields I need aren't listed. How can I get it to recognize all the fields; or, alternatively, how can I redefine the data I need as a field that will show up in the pivot table field list? Thanks. |