Monthly Archives: August 2013

Access Devs For PowerPivot

I bet everyone who comes here can agree on one thing .. that DAX is not intuitive for the traditional Excel user/dev (?).  Well, I too I was fighting DAX, and then one day I took out my Excel brain … Continue reading

Posted in Access, Excel 2013, Microsoft Access, Microsoft Access 2013, Microsoft Excel 2013, Office 2013, PowerPivot, VBA | 3 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 | 26 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