In order to update the workbook, go to the Applications module and simply select the Excel file by clicking on the Spreadsheet File drop zone or drag and drop your file into the browser window.

Upon updating the model and pressing the Update button, all of the named ranges will be updated and SpreadsheetWeb’s internal system validation will run to ensure that the new model is compatible with the existing user interface, database, and page design.

If there are any incompatibilities, the system will redirect user to the Validation Messages screen, where these issues will be further detailed.

PS: Updating the Excel model from the design mode will not affect any published versions of the application. The published version will continue to utilize your existing calculation engine until the new version is published, at which point the new Excel model will be the production version.