I have created a demo application (see attached) that uses InputSum() to allow the user to make changes to data that was loaded a QlikView table - they can then use the "Export to Excel" feature to write the amended data to the source spreadsheet.
Although this method of offering the user a means of updating the values is a little crude it works, partly. You see, the figures that are being displayed are Sales/Forecast figures - in other words for the months that have elapsed (i.e. January through to August) the table shows "Sales" and for the remainder "Forecasted Sales" - the idea is to allow them to edit ONLY those months that have not yet elapsed.
Have a look at the attached example and let me know if you can think of a better way to handle this requirement.
