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 GardnerIT AdminAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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 GardnerIT AdminAuthor 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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.