What Is the SAC Excel Add-in?
The SAP Analytics Cloud (SAC) Excel Add-in—sometimes referred to as SAC for Excel or the SAC add-in for Microsoft Office—connects SAC directly to Microsoft Excel. It allows users to pull live SAC data into spreadsheets, perform planning and analysis tasks, and push updates back into the system, all without leaving Excel.
Essentially, it combines Excel’s flexibility with SAC’s governance, collaboration, and live data connectivity. For organizations balancing speed, familiarity, and control, the Add-in is increasingly becoming a core part of the finance workflow.
The Excel Debate: Friend or Foe?
Excel has been the backbone of finance and planning for decades:
Why it’s loved:
- Flexible for ad-hoc analysis and modeling
- Familiar to finance teams
- Fast to set up and iterate
Why it’s criticized:
- Prone to errors from manual inputs and static formulas
- Hard to maintain governance and version control
- Challenging to scale for enterprise-wide collaboration
The SAC Excel Add-in doesn’t replace Excel—it enhances familiar workflows by integrating SAC governance, live data, and collaboration features. Recent updates in 2025 make these enhancements more visible and practical for daily use.
What’s New in the SAC Excel Add-in
Finance teams rely on Excel for flexibility, but SAC provides governance, collaboration, and live data. Recent updates have turned the SAC Excel Add-in into a bridge between these two worlds, delivering both speed and control. Here are the six most impactful new features:
-
-
- Story-to-Excel Tables
- What it does: Transfer tables from SAC Stories into Excel, keeping filters, variables, dimensions, and measures intact.
- Why it matters: Analysts can quickly move from dashboards to granular analysis without rebuilding queries, saving time and preserving context.
- Data Point Comments & Collaboration
- What it does: Add and view comments on individual cells, synchronized with SAC. Retrieve comments programmatically with SAP.GETDATACOMMENT.
- Why it matters: Enables real-time collaboration and makes qualitative insights actionable for reporting, dashboards, and KPIs.
Comments are edited and shown in the new tab Data Point Comment in the designer panel. Image source: SAP
- Enterprise Governance Inside Excel
- What it does: Data Access Controls (DCS) and validation rules from SAC now apply in Excel tables.
- Why it matters: Reduces risk from manual spreadsheets while allowing teams to work in a familiar tool.
- Drag-and-Drop Table Builder
- What it does: Drag dimensions and measures from the permanent pane into table rows or columns; resizable pane and search make object selection easier.
- Why it matters: Streamlines analysis, reduces clicks, and speeds up common tasks for planners and analysts.
- Styling & Formatting Enhancements
- What it does: Apply corporate color and custom styles to contiguous or non-contiguous cell ranges.
- Why it matters: Creates cleaner, more consistent layouts for reporting, presentations, and stakeholder communication.
The option Apply Default Format is now available as a setting on the Styling panel. Image source: SAP
- Restricted Measures & Accounts
- What it does: Create and edit restricted measures and accounts directly in Excel for advanced planning comparisons.
- Why it matters: Supports subset analysis and variance reporting without rebuilding tables, reducing errors and improving insight accuracy.
Add restricted measures and restricted accounts in your table by excluding certain members of one or more dimensions. Image source: SAP
- Other Notable Updates from 2025
- Support for VBA macros in Excel desktop workbooks
- Optimized planning area and improved data action triggers
- Front-end calculations anchored to totals
- Improved workbook design and object management
- Sign-in improvements and multi-tenant support
- Story-to-Excel Tables
-
Why These Updates Matter
These updates show how the Add-in can enhance existing workflows without forcing teams to change tools. Finance and planning teams gain:
- Faster analysis with drag-and-drop and story transfers
- Better collaboration with comments and formula enhancements
- Stronger governance and reduced spreadsheet risk
- Clearer reporting with styling and restricted measures
Practical Takeaways for Finance Teams
- Update to the latest version to access all features.
- Pilot high-impact use cases such as forecasting, reconciliations, or variance analysis.
- Align with SAC governance rules to enforce security and data integrity.
- Educate users on new drag-and-drop functionality, comments, and restricted measures to maximize adoption.
Tips to Apply the New Features
- Leverage story transfers: Move tables from SAC dashboards into Excel to perform deeper what-if analysis without rebuilding queries.
- Use data point comments: Add context directly in Excel cells, and retrieve commentary in reports or dashboards with SAP.GETDATACOMMENT
- Apply governance rules: Verify that Data Access Controls (DCS) and validation rules are working as intended inside your tables.
- Streamline table building: Use the drag-and-drop pane to add dimensions or measures quickly when designing tables.
- Standardize formatting: Apply corporate styles and thresholds for cleaner, more consistent reporting.
- Take advantage of restricted measures: Create subset comparisons and variance analysis directly in Excel.
- Explore the resizable builder panel: Keep the object list open for faster access to dimensions and measures during analysis.
