Jean Paul's Blog

There are 2 types of People in the World, One who Likes SharePoint and..

    Advertisements
  • Microsoft MVP

  • MindCracker MVP

  • CodeProject MVP

  • eBook on SharePoint 2010

  • eBook on Design Patterns

  • eBook on Windows Azure

  • NLayers Framework @ CodePlex

  • MSDN Forums

  • .Net vs. Java

    Due to Public Demand
  • Advertisements

Hiding Download Option of Excel Web Access Web Part

Posted by Paul on January 19, 2015


In this article we can explore how to hide the download options of an excel web access web part.

In the previous article we have observed how to use an excel web access web part.

http://www.jeanpaulva.com/index.php/2015/01/17/using-excel-web-access-web-part/

Advantages of Hiding

Following are the advantages of hiding:

· Prevent users from procuring your proprietary formulas & calculations

· Show a read-only view to the user

Download Options

Following are the download options available:

image

Download option allows downloading of entire file. In this way the entire excel workbook can be protected.

Download a Snapshot allows downloading of only values & formatting. In this way the proprietary formulas and calculations can be protected.

Prevent Download

Open the page in edit mode & choose the Edit Web Part option of the excel web access web part. Uncheck the option Open in Excel, Download, Download a Snapshot.

image

Save changes & Refresh the page. You should be seeing the Download options are hidden now.

image

References

https://technet.microsoft.com/en-us/library/ee424405(v=office.15).aspx

Summary

In this article we have explored how to hide the download options of an excel web access web part.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s