You can add up to 2 millions users in single site collection. MSDN Source
You can add up to 30,000,000 documents per document library MSDN Source
The maximum size of a workbook that can be opened in Excel Services is 10 MB. MSDN Source
You can manage up to 400,000 versions of items/files in list/library.
For more limits and boundaries of SharePoint
Yes there is.
Open your spreadsheet in Excel client application. Select the cells you want to disable from clicking. Go to the review tab, and select protect sheet. Uncheck the "Select locked cells" and "Select unlocked cells", save the spreadsheet and upload it to SharePoint again.
I can't explain it, but it seems I was experiencing a bug. I changed one of the rules to make the grid lines red instead of making the fill red, and all of the sudden all of my rules starting working on SharePoint.
I couldn't comment on Vishal's answer so I will have to write my own.
The users limit is 2 million in a single site collection.
As previously mentioned you can add up to 30,000,000 documents per document library or 30,000,000 items per list.
Again, as previously answered by Vilash you can also manage 400,000 versions.
It is worth noting though that these ...
Best way is to make those charts as named Parts and then specify that name in Excel web access part . You should see only that Chart. Also in web part setting if you chose toolbar none, you wont see file tab or other excel function. It will be visible as plain Web chart and they wont know its actual excel file.
The images will be static, but that sounds like what you want. For SharePoint Online, you will have to use the Graph API instead.
The linked picture feature is not supported in Excel Online and Excel Web Access web part.
As a workaround, use cell references instead.
In the Summary worksheet, click on a cell and enter “=” in the cell.
Then, navigate to sheet 2 “Scope”, select the first cell of your data and press “Enter”. (Demo: column-A, row-1)
Back to Summary sheet, pull down +. ...
SharePoint online use Excel Online Web App instead of using Excel service.
Follow the steps below to add connection to SPO list instead of using “Export to Excel” function, see if the refresh works:
Create a excel file in client.
Get external data from ODate Date Feed.
Link to https://tenant.sharepoint.com/yoursite/_vti_bin/listdata.svc.
Select the lists ...
Access web apps no longer run in SharePoint online and migrating this database will not be possible. If the business still requires this functionality, you need to look into other options, for example Power Apps as the user interface for data stored in SharePoint.
Edit: Microsoft announced the death of Access web apps for SharePoint online in March 2017. ...
This is design. The excel file in the embed web part can only be displayed a part. You could not adjust the size of the embedded web part or the excel file. The only way is click the Full Screen at the Lower right corner of the web part. This would open a new tab for the file.
Follow the points below to troubleshoot this issue:
Navigate to the library which the excel file come from, check if the user has permission to the file.
Edit the Excel Web Access web part, check if it is set Target Audiences in Advanced section.
Switch to another browser or clear the browser cache to check again.
That's correct, Excel Online (be it via SPO, WAC, or OOS) will not allow you to open password protected files (be it the workbook or one or more sheets) in the browser.
There is a good description of the limitations/differences on the article Differences between using a workbook in the browser and in Excel.
Here's what I did to hide the breadcrumb navigation on the xlviewer.aspx page. I added the following CSS directly in the page:
I suppose the issue is caused by the excel will record the last used cell when saving the file. When opening the file again, it will automatically redirect to that cell. So that, it will automatically navigate to the middle of the excel file when opening it using Excel web part because the last used cell is in the middle.
You can follow the steps below to ...
I haven't seen the issue before but have a couple of suggestions.
If it is a caching issue as you say, then try an IISRESET on your web front end
Otherwise it may be a web part restore issue, maybe a hard coded site ID in the settings, create a new excel web access web part on the site and see if it works. If so, delete the web parts and re-create them.
I resolved this pesky warning by doing the following:
Open Document in Microsoft Excel
Select Data > Get Data drop down > Query Options
Went to Security > changed Web Preview Warning Level to 'None'
I also updated Privacy to 'always ignore privacy level settings'
You don’t need to add items to an Excel file using flow.
Add connection to SPO list in a Excel file and upload the excel file to SP Online library. Configure Refresh control for this data connection. We can refresh data automatically when opening the file or configure it to refresh automatically every specific minutes. After that, you can display the data ...
You can follow the steps below to add connection to a SP Online list and upload the excel file to a SP Online library. The data in the workbook will refresh automatically if the refresh control is enabled. After that, you can display the data using Excel Web Access web part.
Create a excel file in client.
Get external data from ODate Date Feed.
Link to ...
As you know excel service application is now part of OOS, You need to configure it then yes it will fix the error.
If you currently use Excel Services in SharePoint 2013 and upgrade to
SharePoint Server 2016 you must also deploy Office Online Server with
Excel Online to ensure Excel Services functionality remains available.
The following Excel ...
This has to be done in the actual Excel file.
Row and column headers are easy removed, to get rid of the scroll bars i think you have to use multiple sheet to keep the content size from generating a scroll bar, or if you can set the web part width and height in SharePoint so the whole sheet is visible and thus removing the scroll bar.
How to display or ...
Permissions are not given by columns, they are given by item. So, if you don't want a user to edit a certain item/list you have to change the permissions on that item/list.
Here is how to do this:
Edit permissions for a list, library, or individual item
There is no real time update possible.
Business Data Webparts are not available on all of Small business plans, it’s only available on the Enterprise Plan E3 and E4.
You can get the details list of features across all office 365 plans check this technet.
Feature availability across SharePoint plans
Also read this one http://itfreesupport.com/2014/12/in-sharepoint-online-office-365-under-...
For those who may stumble across this - It's not possible Pre 2013
The link I followed to complete this is as follows:
Thanks anyway guys
I'm aware this got down voted but in case anyone has a similar issue:
To fix our issue the data in the spreadsheet had to be set to 2 decimal places e.g. 10.50%, the web part for whatever reason would not accept 1 decimal place for example the format the user wanted was 10.5%.
You can save your excel document as an XPS file. Use "Save As" in Excel.
Upload saved XPS file to your SharePoint site.
Copy URL of XPS to text file.
On SharePoint site, add a page viewer web part to page. Add copied URL to link block and click Ok or Apply. Depending on size of the chart(s), you will need to adjust the height and/or width of web part ...