Keep it secure Until I used a password manager I struggling several times with passwords. Now I use on the PC (https://keepass.info/) and on my mobile https://minikeepass.github.io/. The file I share on my home owncloud installation. With this in place, I can use generated strong passwords longer then 20 characters long. I have on demand […]
Read more "Passwords"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"