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?
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
66,548
Office Version
  1. 365
Platform
  1. 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.
 
Upvote 0

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.
 
Upvote 0

Logit

Well-known Member
Joined
Aug 31, 2016
Messages
4,580
.
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:
Upvote 0

SpillerBD

Well-known Member
Joined
Jul 2, 2014
Messages
2,851
Office Version
  1. 365
Platform
  1. Windows
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?
 
Upvote 0

Forum statistics

Threads
1,187,138
Messages
5,961,766
Members
438,563
Latest member
Ron Gluck

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top