SAP Knowledge Base Article - Public

3550892 - Columns width/size is getting adjusted on their own at the max sizing when refreshing data in SAC Excel Add-In

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

  1. Create a new workbook in SAC Excel Add-In
  2. Insert some data and save the workbook
  3. Close and open the workbook again
  4. 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

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

Product

SAP Analytics Cloud, add-in for Microsoft Office all versions