| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel hangs when there are 30 or 40 files open
Hi I have Excel 2007 with Windows XP and 4GB's of RAM, Is there a way to
optimize memory so Excel can stop hanging when there are too many files open or do we have to live with this problem? Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel hangs when there are 30 or 40 files open
Hi,
There are no ways I know of to optimize Excel's memory usage. You 1. could close all other applications 2. Open fewer files (it's probably not really the number of files but their complexity and size), 3. Free up more hard disk space sometime helps, 4. Changing the swap file size in Windows may also help, 4. defragging the hard disk might help. Excel 2007 allows up to 2GB of memory usage (supposedly). But XP only supports up to 3 GB (32 bit system). I did a little test on my machine and had no problem opening 100 blank files without crashing. I'm on Vista with Office 2007 in this case. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Vic Abrahamian" wrote: Hi I have Excel 2007 with Windows XP and 4GB's of RAM, Is there a way to optimize memory so Excel can stop hanging when there are too many files open or do we have to live with this problem? Thank you |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel hangs when there are 30 or 40 files open
It's probably complexity of the files and some of them are 100 or more tabs
and linked to other files etc.. How do big company's who need to have huge excel files etc. do it then? Do they use lots of small files or do they use a different application I wonder. "Shane Devenshire" wrote: Hi, There are no ways I know of to optimize Excel's memory usage. You 1. could close all other applications 2. Open fewer files (it's probably not really the number of files but their complexity and size), 3. Free up more hard disk space sometime helps, 4. Changing the swap file size in Windows may also help, 4. defragging the hard disk might help. Excel 2007 allows up to 2GB of memory usage (supposedly). But XP only supports up to 3 GB (32 bit system). I did a little test on my machine and had no problem opening 100 blank files without crashing. I'm on Vista with Office 2007 in this case. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Vic Abrahamian" wrote: Hi I have Excel 2007 with Windows XP and 4GB's of RAM, Is there a way to optimize memory so Excel can stop hanging when there are too many files open or do we have to live with this problem? Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel hangs when trying to open a file but it's ok if i open exce. | Excel Discussion (Misc queries) | |||
| excel hangs after giving File Open | Excel Discussion (Misc queries) | |||
| Excel 2003 hangs when trying to locate a workbook to open | Excel Discussion (Misc queries) | |||
| a certain excel file hangs up when i open it | Excel Discussion (Misc queries) | |||
| excel file hangs when you open it. | Setting up and Configuration of Excel | |||
Linear Mode
