You can create a macro that once you are done entering data in input file, you execute it and it changes data in calculation and finally output file.You will have to open the calculation file, but you can do this without the user seeing it open (by putting Application.Screen Updating = False and application.displayalerts=false) you then do the changes and then close it and save it through the macro.You have the options of hardcoding the locations of the files on the directory - or have them all together in one directory and let the macro figure it out, or add a pop-up that asks the user to locate the file - filetoopen = Application.Get Open Filename(Filefilter:="Excel Files (*.xls),*.xls", Title:="Find my Calc file", Multi Select:=False).
The cell references were all correct, but for whatever reason they would not update.
I tried a couple of things - "Formulas - Automatic" was checked, clicking "Calculate Now" and "Calculate Sheet" would not update the model.
The only way the to update the cell is to click on the formula and hit Enter or Tab.
I tested the issue out on a couple of new speedsheets (both saved on the same shared drive) and it's still happening.
Not sure if its just my computer yet, currently testing the issue with different computers.