secure a spreadsheet on sharepoint

Posted on 2011-04-20
Last Modified: 2012-05-11
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.
Question by:smurfer69
    LVL 6

    Expert Comment

    LVL 6

    Accepted Solution

    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:

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    Title # Comments Views Activity
    Access VBA - Convert to Number 6 35
    make top menus bigger font 3 23
    MS Excel Cell questions 5 39
    Search multiple lines 3 24
    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. …
    This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
    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 …
    This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now