Large Excel files and resources

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
Damian_GardnerAsked:
Who is Participating?
 
JohnBusiness Consultant (Owner)Commented:
You should probably move this user right away to Office 2016 64-bit. The 64-bit version will provide more resources and should solve your problem. There would be no point now trying to find Office 2010 64-bit.
0
 
Dustin SaundersDirector of OperationsCommented:
The newer versions of office I've found to be worse with massive sheet calculations.  

That being said, you're really pushing Excel on what it can do and the suggested course of action is to move the data out of Excel and into a more usable format.  If you don't have experience creating applications, Access is a simple entry point to a better data management solution.
0
 
Damian_GardnerAuthor Commented:
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.
0
 
JohnBusiness Consultant (Owner)Commented:
You are very welcome and I was happy to help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.