Update an Application Workbook - SpreadsheetWeb Help
SpreadsheetWebHelp center
Sign inTry for free
Course contents9 lessons
Course overview
  1. Prepare Your Excel File
  2. Upload Your Excel File
  3. User Interface
  4. Navigation and Pages
  5. Database
  6. Print
  7. Email
  8. Publishing Your Application and Transactions
  9. 09Updating the Workbook

Lesson 9 of 9

Updating the Workbook

Update a published SpreadsheetWeb application by downloading its Excel model, uploading the revised workbook, and publishing a new transaction.

2 min read

Update the calculation logic, lookup data, or default values behind an existing SpreadsheetWeb application without rebuilding its interface. Workbook updates are made through a new application transaction, so the current published version remains available until the revision is published.

Download and revise the Excel model

  1. Open the application's entry in the control panel.
  2. Select Download Excel Model next to the application name.
  3. Open the downloaded workbook in Excel.
  4. Make the required changes to formulas, data, formatting, or other model content.
  5. Save the revised workbook.

The video demonstrates changing a product price, but the same workflow applies to other workbook revisions.

Upload the revised workbook

Open the application in the Designer. Updating the workbook begins a new work-in-progress transaction.

  1. Go to Edit Application.
  2. Select the revised Excel file.
  3. Choose Update to replace the model in the current transaction.

If the update adds, removes, or renames values used by the web interface, review the User Interface Designer as well. Controls bound to changed named ranges may need to be added, removed, or remapped. A data-only or formula-only change may not require interface edits.

Publish and verify the update

Preview the work-in-progress version and test the calculations affected by the workbook change. When the results are correct, publish the transaction.

Publishing makes the revised workbook the active model. Users who open the application after publication will work with the latest formulas and data, while the application's transaction history preserves the earlier published state.