You now can deselect the default format setting in a table while using SAC Excel Add-in. Select the three dots and deselect “Apply Default Format.” Doing so will allow the user to use Excel workbook formatting vs. SAC.
Please note, the table will retain the formatting you’ve applied, except when hierarchies are expanded or contracted.
If the table you build is static, then this enhancement may work well for your reporting.
The table below had been formatted prior to adding another year, but the blue row formatting did not carry over once the table was expanded to support the additional year. The same issue will be encountered when expanding/collapsing the hierarchies.
