<div>
ok - thanks John and Dustin. &nbsp;This was a 3rd-party created solution for our sales force, in Excel, unfortunately. &nbsp;We're not able to quickly convert it to Access, so I'll have to try the 2016 Office version, and go from there. &nbsp;Thanks guys.
</div>


ok - thanks John and Dustin.  This was a 3rd-party created solution for our sales force, in Excel, unfortunately.  We're not able to quickly convert it to Access, so I'll have to try the 2016 Office version, and go from there.  Thanks guys.

<div>
You are very welcome and I was happy to help
</div>


You are very welcome and I was happy to help

<div>
<div class="content wysiwyg-content">
Hello - I'm an IT admin and I have some users who have been given some rather large spreadsheets (50-100MB) that perform calculations, and they have problems with running out of resources, application crashes, or screens freezing. &nbsp;My question is how do I know if the computer that is trying to run these large spreadsheets is simply not resourceful enough? &nbsp;Are there tricks to getting large spreadsheets to calculate more efficiently? &nbsp;what should I check? BTW - We're still on Office 2010 (soon will be upgrading to 2016), and we have tried running the sheets on Win 7 &amp;&nbsp;Win 10<br />
<br />
thanks,<br />
Damian
</div>
</div>


Hello - I'm an IT admin and I have some users who have been given some rather large spreadsheets (50-100MB) that perform calculations, and they have problems with running out of resources, application crashes, or screens freezing.  My question is how do I know if the computer that is trying to run these large spreadsheets is simply not resourceful enough?  Are there tricks to getting large spreadsheets to calculate more efficiently?  what should I check? BTW - We're still on Office 2010 (soon will be upgrading to 2016), and we have tried running the sheets on Win 7 & Win 10

thanks,
Damian

Large Excel files and resources

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

Spreadsheets

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.