Data source for PivotTable-Form in ACCESS 2000

H

Helmut Kotsch

Hi, this drives me crazy,

4 years ago I defined in an ACCESS 2000 application a "PivotTable-Form". The

resulting EXCEL table inclusive the "Data refresh" works perfect. I now want

to update/change the query for the "Data Source" but cannot find which query

is behind the "PivotTable-Form" or behind the resulting EXCEL spreadsheet.

When editing the properties for the "PivotTable-Form" or the EXCEL

spreadsheet the "Data Source" is always blank.

Question: Where does Access 2000 or EXCEL 2000 hide the respective data

source (Query)??

Helmut
 

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

Similar Threads

Retrieving data in pivottable from Access / SQL server 3
Retrieving data in pivottable (Excel) from Access / SQL server 0
How to maintain dynamic data range for Excel PivotTable 4
ODBC Data Source - Excel 2010 0
Use FileMaker data as source for PivotTable xl2004 9
Excel Pivottable using data in Access 2002 2
User Defined Function not allowed in Excel Query of Access DB? 4
Pls assist How 2 find Mystery in complex pivottable data source base on access 1

Top