I am trying to maintain a complicated workbook for a group of people that will need many future updates and tweaks. I was wondering if I could provide them with a front-end that would be able to populate the formulas used to do their calculations from an external file so that I can revision the formulas as needed without versioning an updated file and pushing it down to them.
If there is an alternative method of obtaining the same results, I would welcome that as well. If Excel is not capable of performing this specific function, then it may be time for me to learn how to code this into a website.
Thank you for your help in this matter.
Bookmarks