VBA - Excelerator BI

VBA

Open the Queries and Connections Pane Wider

Power Query for Excel has developed at a striking pace over the last few years making it hard to keep up with the changes.  Over several iterations, the Queries and Connections pane has been called …

Open the Queries and Connections Pane Wider Read More

Extract Measures from an Excel Workbook

I was working with a client last week and the unthinkable happened.  The client made a simple editing mistake inside the Measure editing dialogue box and it corrupted the Power Pivot workbook. We could still …

Extract Measures from an Excel Workbook Read More

Excel Keeps Crashing? Check your VBA code

I use Excel 2013 64 bit and sometimes Excel just keeps crashing on me.  It used to happen to me a lot more in the past, but after I discovered what was causing the repeat …

Excel Keeps Crashing? Check your VBA code Read More

How to Copy and Load VBA for Excel

I love VBA for Excel. VBA can automate tasks that you use often, making the process faster, easier and more accurate to execute. I like writing VBA for myself to solve my own problems, I …

How to Copy and Load VBA for Excel Read More

Create Incremental Backups when using Power Query

Edit 16 May 2015: I now know the exact cause and cure for this problem.  See this post here This backup tip is still useful though. This is a follow up to this post where …

Create Incremental Backups when using Power Query Read More

VBA to Insert a Power Pivot Table

When Power Pivot was originally released by Microsoft, it was introduced as a Plug-In to Excel 2010.  After the second version of the Plug-In was built and released, the Microsoft Build team moved its focus …

VBA to Insert a Power Pivot Table Read More

Use Simple SQL to Manage your data in Power Pivot

When I started learning Power Pivot, I learnt there are 2 ways to import data. There is the “standard way” that uses the table import wizard – good for us Excel folk. There is a …

Use Simple SQL to Manage your data in Power Pivot Read More

How to Bulk Refresh PowerPivot Workbooks on your PC

There are a number of different ways that you can refresh PowerPivot workbooks automatically on a schedule. The main ones I know of are: Using Power BI Using SharePoint Auto Refresh Using some sort of …

How to Bulk Refresh PowerPivot Workbooks on your PC Read More

Scroll to Top