Can anyone please tell me whether, having created a “private” list view in SP 2013, that view can then be made available to any other users, or whether it really is private?
My scenario is that I’ve linked a SP list to Excel for analysis and reporting, but colleagues seem unable to see the linked data in the spreadsheet when they refresh the link. I’m assuming this is because they cannot see my private view. I’d prefer to keep the view private. Is my assumption right, and if so, what’s the best way to get around this?
Thanks in advance 🙂
Hi Graeme,
Exporting to Excel is the easiest way view data from excel. However, when you do this all you are really doing is having SharePoint create the query for you. There is no reason why you can’t setup your own excel document and link it to SharePoint using Odata as SharePoint has been an OData producer since SP2010. It’s not something I have done myself, but an example of setting up an OData connection to SP can be found here: http://tavislovell.com/create-a-dashboard-from-your-sharepoint-list-data-using-excel-services-and-the-excel-web-access-web-part/
