STARTEXCELPIVOTING() Function example
The STARTEXCELPIVOTING control function collects all database relevant information from a table object containing a database query and opens an Excel* pivot table corresponding to the database query in the table object specified in the formula. The formula works in the Designer as well as in the browser.
The attached zip file contains a working example, the connection files and a sample access database(training.mdb) that is used with the application.
The links to the arcplan application Designer online help for the following used functions are here:
And a link to the Attachment