locked
Sharepoint 2010. Export to Excel One way synchronization RRS feed

  • Question

  • I need to modify the Export to Excel feature so that the user can only view the data in excel but is not able to change the data of the lists through excel. Is there any way to achieve this, any permissions levels or any modifications?

    Thanks

    Wednesday, August 1, 2012 9:08 AM

Answers

All replies

  • An Export, by nature, is a copy of the data saved to a different format.  So, what makes you believe that the user is altering the live data? (This would be a link, not an export.)

    In the case that you did have a link, then the security paradigm would respect the permissions granted to the user.


    Steve Clark, MCTS | Twin-Soft.com & Easy Bins Dumpster Rentals of Northern VA. (Specializing in driveway-sized roll-off dumpsters.)

    Wednesday, August 1, 2012 1:38 PM
  • Hi,

    What you want is the default behavior of SharePoint.

    After exporting a list to excel, you can overwrite data in excel. But the changes you make in Excel won’t change the data in SharePoint list. And when you click refresh in Excel, the excel data will be replaced by the current list data.

    Please check this article for more information about this feature:

    http://office.microsoft.com/en-us/sharepoint-server-help/synchronize-a-sharepoint-list-with-a-spreadsheet-program-HA101854204.aspx?CTT=1

    Thanks


    Pengyu Zhao

    TechNet Community Support

    • Marked as answer by Pengyu Zhao Thursday, August 9, 2012 2:20 AM
    Thursday, August 2, 2012 7:23 AM