Maximum data in a workbook

Copper Contributor

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. 

2 Replies

 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.

 

NikolinoDE

I know I don't know anything (Socrates)

@KristenF

@NikolinoDE thank you for the quick reply! We are going to check out the links, thank you again! Much appreciated.