Basis is the table The basic for an efficient pivot usage is the consequent use of the table. Define the table and convert it to a table. If you specifiy already the table capture ensure the checkbox is tagged. If not Excel will create automated column captures for you. If you use a lot of […]Read more "Combination of a table and pivot"
Update of an Excel database query to update pivots A database query (e.g. ODBC database connection to a MySQL db) to update a pivot is a very powerful mechanismn. Usually to refresh the pivot the user has to trigger it manually. To refresh several files automatically I used the following scripts as a combination of […]Read more "Pivot query update with Excel"