Symptom
- Users cannot save/overwrite an Excel add-in workbook back to SAC folders.
- Save button is enabled and Save As is disabled; clicking Save opens the save dialog and only allows saving as a new file with a different name.
- The issue is file-specific; another workbook in the same folder saves/overwrites normally.
Environment
SAP Analytics Cloud, add-in for Microsoft Office
Reproducing the Issue
- Open an existing SAC Excel add-in workbook from a SAC folder.
- Connect/sign in with the SAC add-in.
- Make a small change.
- Observe that in the affected workbook only Save is enabled, Save As is disabled.
- Click Save and note it opens the save dialog requiring a new name rather than overwriting the original.
- Compare with a different workbook from the same location where both Save and Save As are available and Save overwrites the original.
Cause
The non-working workbook is missing an internal link to its SAC repository resource, while the working workbook has this link intact. This explains the behavior observed: the Save As button is disabled and clicking Save opens a dialog instead of saving directly.
This missing link is the result of a failed initial save operation that occurred at some point in the past on that workbook. When a Save As fails mid-way (e.g. due to a temporary network or authentication issue), the add-in intentionally does not persist the resource link to avoid the workbook being linked to an incomplete file in SAC. At the time of that failure, the following error message would have been shown in the add-in: "The workbook could not be saved on the server (error code: 3)."
This message may have been missed or dismissed. The workbook itself is not corrupted — it is simply in an unlinked state.
Resolution
- Open the affected workbook in Excel with the SAC add-in and sign in.
- Choose Save (which opens the save dialog) and perform a Save As to create a new entry in the intended SAC folder with a new name.
- Close and reopen the newly saved workbook from SAC; verify that both Save and Save As are enabled and that Save overwrites the file.
- Delete the old/orphaned placeholder file from the SAC folder if present.
- If a save error recurs (for example, "The workbook could not be saved on the server (error code: 3)"), capture the exact error message, time, user’s email, add-in version, and steps to reproduce, then contact SAP support.
Note on a recent change in the add-in:
The add-in uses a two-phase upload for Save As: the first upload creates the entry in SAC and returns a resource ID, the second uploads the actual workbook content. As of version 1.25 (released last week), the first upload uses a minimal placeholder workbook instead of the real file, to make failures more visible. If the second upload fails, the SAC folder will contain this placeholder instead of the intended workbook content. If you see an unexpected near-empty workbook file in your SAC folder from around the time the issue first occurred, that is the orphaned placeholder and can safely be deleted.
See Also
Keywords
sac excel add-in, cannot overwrite, save as disabled, save opens dialog, save disabled, overwrite original, repository link, documentresourceid, unlinked workbook, placeholder workbook, uploadnewworkbookpart2failed, error code 3, two-phase upload, sac folders, save failure, The workbook could not be saved on the server (error code: 3), server, write back to server, microsoft excel , KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , Problem
SAP Knowledge Base Article - Public