How do I set Excel to be LARGEADDRESSAWARE?

How do I set Excel to be LARGEADDRESSAWARE?
newparadigmzAsked:
Who is Participating?
 
TeargasCommented:
do you have some sources for that?

as far i could find for excel 2007 there is not an option for that.

http://www.excelforum.com/excel-general/677709-largeaddressaware-excel-2007-from-2-gb-ram-to-4-gb-ram.html

http://www.decisionmodels.com/memlimitsc.htm

"Memory   Usable memory for formulas and pivot caches is increased to 2 gigabytes (GB) from 1 GB in Microsoft Office Excel 2003, 128 megabytes (MB) in Microsoft Excel 2002, and 64 MB in Microsoft Excel 2000."
https://msdn.microsoft.com/en-us/library/office/aa730921(v=office.12).aspx
0
 
TeargasCommented:
as far as i know, just use excel 64bit

"For example, this additional capacity is needed only by those Microsoft Excel users who require Excel spreadsheets that are larger than 2 gigabytes (GB)"

https://technet.microsoft.com/en-us/library/ee681792(office.14).aspx
0
 
newparadigmzAuthor Commented:
I'm running Excel 2007. I've heard you are able to override the default setting though.
0
 
Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
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.