ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Field not visible in ptable field list (https://www.excelbanter.com/excel-discussion-misc-queries/121612-field-not-visible-ptable-field-list.html)

maryj

Field not visible in ptable field list
 
Client is using Excel 2003. She has a pivot table that is linked to an Access
query. When looking at the SQL statement using the addin Pivot Play, we can
see the DeptDesc field. When looking at the field list visible in Excel
ptable, DeptDesc is not listed. However, if we use the option to "Show
detail" from the ptable, there is a column with data for the DeptDesc field.
It appears to be hidden somehow in the ptable field list. Where might this
field be hidden?
--
maryj


All times are GMT +1. The time now is 06:03 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com