I have a spreadsheet template, whihc has a data connection to a access database both of which are on sharepoint. Is there a way that if the viewer saves the spreadsheet that they do not get the data connection.
I thought, by default, viewers will not be able to access the data connection without the proper access.
I think this link is the one that you need:
Note: There are two main ways to deploy InfoPath forms: Server-side and directly through the SharePoint site. Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the
Monte Carlo …