New answers tagged

0

That depends on what level of protection you need. If the Excel file has a workbook password to even open and read, then no, that won't fly. Consider removing the workbook password and use sheet protection instead. People will be able to use formulas that reference locked cells on a protected sheet. If they open the workbook they will not be able to make ...


0

Just to add I have recently used this solution and it worked. The hardest part was mapping the sharepoint to a network drive as I didn't have elevated permissions. The link below helped with this. https://support.microsoft.com/en-gb/kb/2616712 I had much less luck with solutions found elsewhere which mapped and then removed network drives in the sub.


1

You can download them here: code.msdn.microsoft.com


2

You mean like using a link? Such as this one: {Site URL}/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List={List GUID}&View={View GUID}&CacheControl=1 from the post Create Link to Export Library Contents to Excel


0

Double click on bottom right green square Before: After: Will repeat formula on whole column


0

We have now fixed this, it was actually quite simple: Go to IE, Internet Options, Advanced, Untick within the Security section the option called: Do not save encrypted Pages to Disk


0

I was able to pull the membership of a 2013 SharePoint permission group that had 2035 members using the following steps. Note that I wanted the account name only. You may need to modify this process slightly if you want a different field, or more than one field: Page through the group to find out how many members it has Go to Settings/Site ...



Top 50 recent answers are included