Symptom
When refreshing data in SAC Excel Add-In (such as booking or unbooking data), the column width is extended to its maximum size and requires a manual adjustment to fit the desired size.
Environment
- SAP Analytics Cloud, add-in for Microsoft Office
Reproducing the Issue
- Create a new workbook in SAC Excel Add-In
- Insert some data and save the workbook
- Close and open the workbook again
- Click on "Refresh All" option in SAC Excel Add-In and the issue will happen
Cause
There was a bug in Excel with autofit in combination with some number formats.
Resolution
Upgrade Excel to version 2411, as a correction was delivered on December 5th of 2024.
Possible workaround: adjust autofit manually under path Ribbon -> Home -> Cells -> Format -> Autofit Column Width.
See Also
- Request on GitHub: autofitColumns combined with special number format extends column width occasionally
- Microsoft releasing plan: Update history for Microsoft 365 Apps
Keywords
AutoFit, Column, Width, Size, SAC Excel Add-In, refreshing data, booked data, unbooked data, adjustment, table, maximum wide, max, 255, Excel , KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , Problem