How to place field values outside an Excel pivot table ???

J

Jon

I'm working on a simple Excel pivot table based on an ODBC datasource.
The underlying database table includes a field (not part of the pivot
table) that holds a 'Page Title' field. I'd like to access this field
from outside the pivot table so that I can place it at the top of the
spreadsheet, for example in Cell [A1]. This field 'Page Title'
contains the same value for all records in the table.

Is it possible to put this field data in a cell outside of the pivot
table? How do you do this? BTW, I tried placing the field in the
'Page Area' of the PivotTable, but it defaults to 'ALL'. If I could
default it to the single data value, that approach would work also.

Thanks
Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top