PDA

View Full Version : Changing power pivot table appearance



numerouno
2016-05-22, 02:50 PM
Hello all,

I am reading PowerPivot and PowerBI by Robert Collie I notice his PowerPivot tables appear with a nice green theme, in Excel 2016 mine always show with boring grey cell background theme. Can anyone advise how to change this.

Ken Puls
2016-05-31, 10:54 PM
Downgrade to Excel 2010/2013? :)

Seriously, if you're on 2016, they redesigned it to actually be a bit easier to read (with heavy row separators every four rows).

You could try Kasper's old trick (http://www.powerpivotblog.com/wow-how-did-you-get-that-fancy-powerpivot-window-color/), but I couldn't get it to actually work in Excel 2016.