Laptops and large Excel files

PierremontQuaker03

New Member
Joined
Nov 9, 2019
Messages
5
Hi,
I have started a new job which is heavily excel driven, I have encountered a few laptop issues with speed but mainly excel files failing as it "does not have enough resources" to complete the actions - so I have to close down Excel, re-boot etc etc
When I look at the spec of my laptop it is 4.00 GB , yet I have checked others in the accounts team and they all have 8.00 GB.
I have spoken to the IT dept and they have said that my laptop is perfectly fine to do my job and that it is the graphics in the Excel files I am using (I did not create them) that are causing the issue. I am not too sure whether they are trying to fob me off or whether I should push harder for a new one or to increase the RAM size to 8.00 GB (they said excel files over 2GB are blocked so 4GB is more than enough). How do I reduce the graphics on an excel file - or go about reducing its size etc etc.
Many thanks in advance
 

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
6,883
Office Version
2019
Platform
Windows
What is the actual file size?

While graphics (embedded images) might inflate the size of the file, I doubt that they should affect performance too much.
 

ISY

Board Regular
Joined
Nov 16, 2009
Messages
223
Hi,

Laptop W10
Today I use Excel 365 64 Bit - 6 Gh Ram
Previously I had problems Memory Excel 2013 - 4Gh Ram
 

NdNoviceHlp

Well-known Member
Joined
Nov 9, 2002
Messages
2,298
Maybe an office installation issue... there can be a 32 or 64 bit installation. To reduce the file size, zip the file then unzip it. HTH. Dave
 

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
6,883
Office Version
2019
Platform
Windows
This could be worth a read. https://docs.microsoft.com/en-us/office/troubleshoot/excel/clean-workbook-less-memory

You might find that there is not one specific thing causing the problem, but an accumulation of many small things.

Simple test would be to try the same file on a different laptop with more than 4GB and see if you run into issues, if it does then go back to your IT dept and inform them of this.

18MB is big for an excel workbook, but I don't think that it is big enough to be a problem.
 

Forum statistics

Threads
1,077,662
Messages
5,335,561
Members
399,024
Latest member
rokcel389

Some videos you may like

This Week's Hot Topics

Top