Category Archives: Uncategorized

How To Change Connection Type In Power Pivot

Every day, day in and day out, the most popular posting I have here is this one: https://dmoffat.wordpress.com/2013/08/21/how-you-can-change-to-another-connection-type-in-powerpivot/ and this one: https://dmoffat.wordpress.com/2013/08/14/building-a-flexible-and-efficient-client-side-powerpivot-solution-in-excel-2013-2/ I personally use these techniques all the time, for years now and it is my standard modus-operandi for … Continue reading

Posted in Excel, Excel 2013, Office Automation, OLAP, Power BI, Power BI Desktop, PowerPivot, Process Automation, Spreadsheets, Uncategorized | 19 Comments

Here We Go … REAL JavaScript Macros For Excel ?

I have been completely open and honest (as usual) about my contempt for the useless offerings that Microsoft has tried to pass for “Automation” in Excel using JavaScript.  Their concept of “Add-Ins” which do little more than allow you to … Continue reading

Posted in Analysis Services, Cloud, Excel, Office Automation, OLAP, PowerPivot, Process Automation, Spreadsheets, the Cloud, Uncategorized, VBA | 7 Comments

My Thoughts On Excel TV

Earlier this week I appeared on the Excel TV broadcast with Rick Grantham, Jordan Goldmeier and Oz du Soleil …  It was great fun for sure and I hope it was somewhat valuable to the broad Excel community (and even … Continue reading

Posted in Access, Access Solutions, Business Intelligence, Cloud, Excel, Excel 2013, Microsoft Access, Microsoft Access 2013, Microsoft Excel 2013, Office 2013, Office Automation, OLAP, PowerPivot, Process Automation, Spreadsheets, the Cloud, Uncategorized, VBA | 8 Comments

Microsoft Access Client With SQL RemoteApps and SQL Azure Might Just Be What The World Is Looking For About Now

OK … Here we go… Enough time has elapsed since the teaser about “Access Forever” … Today I am going to build a case for using Access Client Software forever (or effectively forever) in the Cloud and on any device. … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , , , , | 34 Comments

Referencing Workbook-Level Range Names In An Inactive Workbook

I was never satisfied with all the stuff on the Internet about referencing Workbook Level Named Ranges in other open spreadsheets.  So a looong time ago I dinked around and came up with this syntax: Range(activeworkbook.name & “!Accounts”).address That worked great for … Continue reading

Posted in Uncategorized | 6 Comments

The Microsoft Rapture

Read this link before reading my comments here: http://www.geekwire.com/2014/internal-memo-microsoft-cut-external-staff-18-months-requiring-six-month-break/ I believe that this (even more than the 18000 announced last week – most of whom are at Nokia) will force a HUGE reorg of Microsoft before the end of 2014 … Continue reading

Posted in Access, Analysis Services, Business Intelligence, Excel, Excel 2013, Microsoft "V-", Microsoft Access, Microsoft Access 2013, Microsoft Excel 2013, Office 2013, Office Automation, OLAP, PowerPivot, Spreadsheets, Uncategorized, V-, VBA | 4 Comments

How You Can Change To Another Connection Type In PowerPivot

I have noticed that it has been noted in a couple of places that once you choose to connect to data in a particular type of data source (i.e. an Access ACCDB file or a SQL Server or MySQL database) … Continue reading

Posted in Excel 2013, Microsoft Excel 2013, Office 2013, PowerPivot, Uncategorized, VBA | 39 Comments

Building a Flexible and Efficient Client-Side PowerPivot Solution in Excel 2013

I considered doing this as multiple blog postings but then as I worked on I thought of how much I hate it when I see “To be continued ….” on the screen at the peak of a TV show … … Continue reading

Posted in Excel 2013, Microsoft Access, Microsoft Excel 2013, Office 2013, PowerPivot, Uncategorized, VBA | 41 Comments

PowerPivot in Excel 2013 Is A Break-Through For All Excel Users

FYI – I, Dick Moffat, have been building spreadsheets for others professionally for data analysis since 1985.  Seriously .  I started using by using VisiCal in 1983. The Data-Centric Spreadsheet For some strange reason when I first saw Lotus 1-2-3 I … Continue reading

Posted in Uncategorized | 6 Comments

Why my blog changed…

Despite not posting since the beginning of the year my traffic has actually gone up every month since.  Interesting.. Thanx for your interest. So why have I not been posting ?  It’s kind of based on the old saying that … Continue reading

Posted in Uncategorized | Tagged , , , | 23 Comments