Formatting of a static report in Microsoft Excel

By Nesha Holmes

Table of Contents

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.

Related Posts

Best Practices

May 30 2024

Unraveling the Benefits of Workplace E-Learning

In today’s fast-paced world, the digital learning space is always changing, making it essential for businesses to keep up. Digital learning is crucial, and

Cindy San

Quarterly Release Cycle

May 22 2024

Planning Trigger – updated formatting options formats

You now have the capability to establish and save default styling preferences for planning triggers. In addition, you can design the triggers using vector

Arthur Phung

Quarterly Release Cycle

May 22 2024

Design Pane Header Re-design

The design panel has separate icons for Tables, Data Action Triggers, and Data Source. The data source name and the table name for tables

Nesha Holmes

Contact Us

Reach out if you have any questions or to see how we can create a custom training solution for your organization!

Contact Form Pop-Up - General Use

Custom Training Solution

Fill out and submit the form below, and we’ll reach out to you to discuss how we can work toward achieving your training goals in a way that works best for you and your team.

Contact Form - Custom Training