Tag Info

New answers tagged

0

The upper boundary for documents is 30 million documents in a library. If you are anticipating this type of growth, you will need to leverage column indexes and ensure you are using filtered views. If you try to render a view that will return more than 5,000 items, you'll throw errors. So don't give out an unfiltered All Documents view. Carefully plan how ...


0

Check your excel settings. Go to File > Excel Options > Trust Center > Trust Center Settings You may find clue for the problem. I had similar issue using Excel and found the solution after i start to explore the Excel security settings.


0

You have to be carefull with opening and closing quotes I copy/pasted your formula (start with 4 spaces so StackOverlfow displays it like code), only added some new lines and spaces for readablity =IF( ISBLANK([DS/F Attachment(s)]) ,"N/A" ,"="<a href='SiteURL/TaskerDocuments/" &[DS/F Attachment(s)] ...


0

Public Const SHAREPOINT_SITE = "-----Sharepoiny Site Name-----" Public Const SHAREPOINT_LIST = "-----Sharpeoint List Name-----" Public Const SHAREPOINT_VIEW = "{328CC815-1952-46A8-BG8B-EE4456AF13E8}" These should be declared and call in the array in the ImportSharepoint function as, Sub ImportSharepointList() Dim ws As Worksheet Dim src(2) As ...


0

1) SharePoint Foundation Server and SharePoint Enterprise are the same on the Server side, it's the client licence which determines the version. So not sure exactly what you are trying to simulate, but server-side it would be the same either way. 2) In theory Office Web Apps will allow collaborative editing, but Excel Online is much better at handling it. ...


0

https://support.office.com/en-za/article/Add-multiple-Office-templates-to-a-document-library-cde94e90-a1ba-4b94-a187-600ed68562bb Created custom content types and follow the above article to add the powerpoint, excel and onenote in the appropriate content type section


0

The solution to this was a lot simpler than I expected: I activated content types for the site and set the Document Status column to 'Hidden' rather than 'Optional', and now the column can't be seen from the Excel. Just thought I'd answer my own post for anyone who finds themselves in a similar situation and comes across this.


0

While it is possible to share Excel files on SharePoint, and view these files with the Excel Web App, it is not possible to run VBA code in a file that only shows in the browser. In order to execute VBA code, the SharePoint user would need to (download and) open the file in desktop Excel. Some security mechanisms may actually prevent the Excel file from ...


0

This problem occurs when Internet Explorer cannot detect the appropriate Office add-on to allow it open the corresponding client application. Unable to detect that Office is installed, Internet Explorer instead helpfully opens the file in the browser. Or not so helpfully, since the Excel web application cannot handle a large number of Excel features that ...


0

You can use the client integration in Firefox and Chrome. But, you need to make sure the 'Microsoft Office' plugin is enabled on either of those browsers. In Firefox: Click on the lego looking thing in the address bar Click "Allow and remember" Then you will be able to open up SharePoint documents in client applications through Firefox. Assuming you ...


0

The version number does not display when using Export to Excel. You have several options: Use a calculated column with value =Version. This formula will work despite the column not being available. [Not recommended due to caching and freezing during export]. Write a VBA function within your connected spreadsheet which will import the version info after ...



Top 50 recent answers are included