Excel file too large to manage

jarreau82

New Member
Joined
Aug 19, 2016
Messages
3
I work in an excel file every week, and the file size is so large it crashes my PC. Is there any way to get around this? Would storing the file in sharepoint be a way of not using my PC's memory to open the file?
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,754
Office Version
365
Platform
Windows
Welcome to the Board!

How much data are we talking about here?

If it is a crazy amount of data, you should probably look at breaking it up into smaller chunks (i.e. if you have a file that has a years worth of data, maybe have 12 monthly files instead).
Or, store the data somewhere else, like in a database program like SQL or Oracle.
 

jarreau82

New Member
Joined
Aug 19, 2016
Messages
3
Welcome to the Board!

How much data are we talking about here?

If it is a crazy amount of data, you should probably look at breaking it up into smaller chunks (i.e. if you have a file that has a years worth of data, maybe have 12 monthly files instead).
Or, store the data somewhere else, like in a database program like SQL or Oracle.

Joe,

Thanks for the reply. I'll try dividing the file up into multiple files. That sounds like the easiest solution.
 

Logit

Well-known Member
Joined
Aug 31, 2016
Messages
2,936
.
If not already done ... convert (save as) the file to .xlsb format. This will significantly reduce the size of the file.

DO SO ON A COPY OF YOUR FILE FIRST !
 
Last edited:

SpillerBD

Well-known Member
Joined
Jul 2, 2014
Messages
2,703
Verify the bit-depth of Excel
Is it a macro enabled book? Are there any Event items?
Do you get an error message or does Excel just close?
 

Forum statistics

Threads
1,085,031
Messages
5,381,303
Members
401,733
Latest member
Kabasa007

Some videos you may like

This Week's Hot Topics

Top