I have a document library that stores Word and Excel files that are used by several people in our company. They access them from a link list. The documents are fillable forms so I have set the permission level to Contribute so they can fill the forms out. The problem is that I don't want them to save back to the SharePoint copy. I want it to always be blank when the next person opens it. I want to force them to "Save As" to their personal folder if they need to Save their copy. Is this possible?
Use content types with document/excel template. You can see how to create a content type with a document template at https://stackoverflow.com/questions/9175300/excel-template-in-sharepoint-how-to-open-as-a-new-file-from-template.
The steps are straightforward: a) create a new content type, derived from document content type and add the document template b) Add the new content type to the list and disable any other content types.
In that way, document templates won't be changed by the users and you can always update them!
Save the file in downloadable format ( Url) , that will allow the user only download the file when they click on it .
Create a folder "Source" Move the file to "Source Folder" Copy the link of the file ( Not the folder) get back to the original destination where file was before moving to source. Click on new (click on link Option under new) there will be popup to paste link , Paste the link copied. To the link at the end add the code as &=Download without space. Save, Your Downloadable format should be ready.
Whenever you want to make any changes in the file , you should be doing in the source file . Do not download , open excel on web and make changes.