Browse by Tags

All Tags » Excel (RSS)

PowerQuery – The power of M

I love PowerBI, actually I love PowerQuery. It's a great way to combine data from around your business, across the web from anywhere. What I really like is very little is done automatically, i.e. it doesn't do the nice data type detection you...
Posted by simonsabin | 1 comment(s)
Filed under: , , ,

Cell Transitions in Excel 2013 Preview–Fixed

If you’ve downloaded Excel 2013 and been working with it you may have noticed the new cell transition feature. Not sure why they put it in, it feels a bit like the aero interface which I understand has been dropped in windows 8. What you may have found...
Posted by simonsabin | 1 comment(s)
Filed under: , ,

data source reference is not valid - Excel error when adding a pivot table

I've had this error a few times but never figured out why. With the help of a few posts around the web I finally found out the reason. If you have opened a none excel file like a csv file, then you get this error "Data source reference is not...
Posted by simonsabin | 1 comment(s)
Filed under: ,