Replace the workbook with a new version

How to bring a new version of your Excel file into an existing service while keeping its inputs, outputs and settings, and what to check before callers get the new version.

What stays and what changes

Each parameter points at a cell by its address, for example Sheet1!B2. After the import it points at the same address in the new workbook. If the new file has the same layout, nothing else is needed.

Replace the workbook

1. Open the service on the Configuration (Konfiguration) tab and wait until the workbook has loaded.
2. Open the three-dots menu (⋮) at the right end of the header and choose Import from Excel (Excel importieren).
3. The dialog Import Excel File (Excel-Datei importieren) says that the current workbook content is replaced and that Your parameters and settings will be preserved. Click Import (Importieren).
4. Choose the new file (.xlsx, .xls or .xlsm).
5. Wait for Excel file imported successfully! Remember to save your changes.
6. Check the parameters (next section).
7. Click Save (Speichern).
8. Click Republish (Neu veröffentlichen) so callers get the new version; see Publish and republish.

If the workbook has unsaved changes, the dialog warns that they will be lost. Save first if you want to keep them, or continue if the new file replaces them anyway.

For a workbook that came from Google Sheets, use Sync from Google Sheets instead; see Import from Google Sheets.

Check the parameters after the import

1. In the panel on the right, click each input and output once. The editor jumps to its cell and selects it.
2. Make sure the cell is still the right one: an input cell holds a plain value, an output cell holds the formula you expect.
3. If a cell moved, hover over the parameter, click the pencil, and correct Cell Address (Zelladresse), for example from Sheet1!B2 to Sheet1!B3. Confirm with Update Parameter (Parameter aktualisieren).
4. Test the service with a few values before publishing; see Test before publishing.

Things in a new file that move parameters away from their cells:

• Rows or columns inserted or deleted above or left of a parameter cell. The parameter keeps its old address and now points at a different cell.
• A sheet renamed or removed. The address carries the sheet name, so the parameter no longer finds its cell.
• An input cell turned into a formula. A call would overwrite the formula with the input value. Point the input at the cell the formula reads from.

Keep the layout stable

The easiest way to make updates safe is to keep input and output cells where they are:

• Add new rows and columns below and to the right of the cells used as parameters, or on another sheet.
• Do not rename sheets that hold parameters.
• Keep inputs and outputs together on one sheet that rarely changes, and let it reference the sheets that do. See Workbook tips.

What callers notice

Nothing changes for callers until you click Republish. Up to then the published service answers with the workbook it was published with. After republishing, calls use the new workbook. Names of inputs and outputs stay the same, so existing integrations keep working; what breaks an integration is described in Rename, reorder and remove parameters.

After republishing, new calls use the new version. How stored results work is described in Caching and performance.

For developers and agents

• Parameters are bound to Sheet!Cell addresses, not to defined names or labels. A replaced workbook is read at the same addresses.
• The replacement changes the draft. Save, then publish, to make it live.
• Size limits apply to the new file as to any import; see File size limits.
• An AI agent connected to the account does not swap the workbook of an existing service. It creates a new service from the changed workbook, or you replace the workbook in the editor as described here; see What an agent can do.

FAQ

How do I update the Excel file of my service?

On the Configuration tab, open the three-dots menu (⋮) in the header, choose Import from Excel and pick the new file. Then check the parameters, click Save and Republish.

Will I lose my inputs and outputs when I import a new version?

No. Parameters, settings, AI descriptions and tokens are preserved. Only the workbook is replaced.

My results are wrong after I replaced the workbook. Why?

Most likely cells moved in the new file, so a parameter now points at a different cell. Click each parameter to see its cell and correct Cell Address where needed.

Do I have to publish again after replacing the workbook?

Yes. The import changes the draft only. Click Save, then Republish; until then callers get results from the previously published workbook.

Does the service address change when I replace the workbook?

No. The service ID, its address and its tokens stay the same.

I renamed a sheet in Excel. What happens to my parameters?

Their addresses still carry the old sheet name, so they no longer find their cells. Edit each affected parameter and correct the sheet name in Cell Address, or keep the old sheet name in the file.

Can I go back to the old workbook?

Before you click Save, reload the page: the saved workbook is loaded again. After saving, import the earlier Excel file again, so keep a copy of each version you publish.

How do I change a parameter's cell without replacing the workbook?

Hover over the parameter in the panel, click the pencil and change Cell Address. Then save and publish again.