Hi Steve,

Adagio does not provide any way to set default Excel table coloring.

When I Googled this question, I found a couple of threads that suggested creating a new default Excel template that has the desired table style enabled. And saved to the XLSTART folder within C:\Program Files\Office - somewhere. Then whenever a new Excel sheet is created in any way, including external sources such as MS Queries and presumably Excel Direct, the new table style will already be set up.

In Excel, you can right-click on a table style to 'Set as Default'.

i suspect this will be an Excel change rather than an Adagio change.