Pivot query update with Excel

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"