-
Archives
- April 2018
- March 2018
- February 2018
- January 2018
- November 2017
- September 2017
- June 2017
- November 2016
- October 2016
- September 2016
- August 2016
- June 2016
- May 2016
- April 2016
- September 2015
- July 2015
- June 2015
- May 2015
- April 2015
- February 2015
- August 2014
- July 2014
- May 2014
- April 2014
- February 2014
- January 2014
- December 2013
- October 2013
- September 2013
- August 2013
- October 2012
- December 2011
- October 2011
- September 2011
- July 2011
- June 2011
- May 2011
- April 2011
- March 2011
- February 2011
- December 2010
- November 2010
- October 2010
- September 2010
- August 2010
- July 2010
- June 2010
- May 2010
- April 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
-
Meta
Category Archives: Excel 2013
Modeloff GTC in New York City – Dec 4-5, 2017
Just a note that I will be in New York on Monday and Tuesday Dec 4 & 5 exhibiting and presenting at: Modeloff GTC New York I will be showing the latest iteration of the XLPublish add-in on exhibit with … Continue reading
XLPublish Is Here !!!
Today Personal Logic Associates Inc. is proud to ship XLPublish – our new Add-in for Excel that makes publishing your Excel data in Power BI Easy, Reliable and Repeatable. With XLPublish you can make your current Excel Ranges, Tables, Pivot … Continue reading
XLPublish Is Almost Here !
This is a heads-up about the imminent release of the new XLPublish add-in written by myself and David Hoppe. If you go to our Website ( xlpublish.com ) there is an explanation of what this is. We will … Continue reading
How To Really Publish Excel Data To Power BI … Part III
OK .. Let’s go … Part III … !! In this post I will try to explain how (and especially how not) to get your Excel data into Power BI Desktop in a way that will allow you to schedule refreshes … Continue reading
How To Really Publish Excel Data To Power BI … Part Deux (amended)
Just a quick note for those that looked at and perhaps tried out the code in the post of a couple of weeks ago ( https://dmoffat.wordpress.com/2016/09/29/how-to-really-publish-excel-data-to-power-bi-part-deux/) . I have made a very small but very important change to the … Continue reading
How To Really Publish Excel Data To Power BI … Part Deux
A couple of weeks ago I published a length post detailing the techniques I have developed to successfully export Excel data to Power BI. I have had some interesting responses and I have since evolved my thinking on this, and … Continue reading
How To Really Publish Excel Data To Power BI
OK .. I’m going to try to make this as short as I possibly can. I am sick of docs that do not explain to people how to REALLY accomplish something 😦 … I want this to be different but … Continue reading
Tech Support Call From 1985
I received THIS request for tech support YESTERDAY … Hi Dick, Would you please tell me what a Code A is and how we fix it. When we try to add soy loads to one of the years we get … Continue reading
How To Change Data Sources Dynamically In Excel With Power Query
My Crow Eating Exercise This past week I asked on this blog whether anyone out there was using the technique I wrote about years ago for dynamically changing the Source Connections for Power Pivot Tables in Excel. I have noticed … Continue reading
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
Dick Moffat's Spreadsheet and BI Blog 