I have excel files on a SharePoint site which I am linking to the company's intranet. The reason we have the forms on SharePoint is that certain people need to update the forms regularly and we want to save the effort of uploading them every time again to the intranet. The form includes a button as a feature that saves a copy of the form on the user's desktop. Problem is that if the user does not use that button but just saves the file in Excel as usual, he would save the entries in the original version in SharePoint, which is to be avoided.
I am looking for a solution to this problem and am not sure there is any, as this is really tricky:
- I want certain few people to be able to edit and save the version of the form directly in the SharePoint
- I want everyone to be able to make entries into the form itself and save it on their end but not save those entries in the file itself on the SharePoint (just as a copy of that file)
I cannot just use a view only link provided by SharePoint, as a) I want them to be able to make entries, b) that link always opens in ExcelOnline instead of Excel, which does not support macros.
Any ideas appreciated. Thanks!