Apr 06 2022 09:23 PM
How much data can a workbook hold before it starts having issues or lagging? We have a lot of specialists working out of a workbook and we want to start imbedding documents, and utilizing all of the different things we can to help our processes. Can anyone give us an idea of how much we can do? Or does anyone know of any good examples we can look at to see different ideas of what we can do?
We have all of the basic macros functions, button, emails etc.
Apr 07 2022 12:48 AM
Excel specifications and limits
General specifications and possibilities
File size limits for workbooks in SharePoint
Microsoft SharePoint has some file size limits for workbooks.
Data Model specification and limits
A data model is embedded data inside an Excel workbook that powers data visualizations such as PivotTables, and Pivot Charts.
Understanding Excel Workbook’s File Size Limits in SharePoint Online
Note: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.
Hope I could help you with these links.
I know I don't know anything (Socrates)
Apr 07 2022 12:52 AM
@NikolinoDE thank you for the quick reply! We are going to check out the links, thank you again! Much appreciated.