Recently switched to Excel 2013 (32-bit) by it department
I now constantly get Excel ran out of resources while attempting to calculate one or more formulas.
In excel 2007 I used the same multiple inter-linking files daily w/o trouble
Using Windows Task Manager: When ever Memory (Private Working Set) for excel goes above 1Gb I start to drag/crash
Have tried to reduce/eliminate volatile formulas... some are necessary --at least boss thinks =today() is necessary rather than a macro to set date each time the file is opened
CPU usage does not max out
Running Windows 7 Professional
4 GB ram
Is there some setting to allow Excel to use more memory?
I now constantly get Excel ran out of resources while attempting to calculate one or more formulas.
In excel 2007 I used the same multiple inter-linking files daily w/o trouble
Using Windows Task Manager: When ever Memory (Private Working Set) for excel goes above 1Gb I start to drag/crash
Have tried to reduce/eliminate volatile formulas... some are necessary --at least boss thinks =today() is necessary rather than a macro to set date each time the file is opened
CPU usage does not max out
Running Windows 7 Professional
4 GB ram
Is there some setting to allow Excel to use more memory?