Excel hang-up/crash problem

  • Thread starter Thread starter gerok
  • Start date Start date
G

gerok

I have two realively large workbooks with macros. Data is to b
exchanged between them. But when I have both two open, Excel jus
halts/crashes without any error message. Separately both works jus
fine (also at the same time running in separate Excel applications).

Any ideas on how to fix this?
Could settings for mermory be the thing? How can I change the me
settings? (i run Excel 2000 on XP Pro.)

Thanx in advance!

Georg Rokn
 
Hi gerok!


Find and Select C:\Documents and Settings\<user>\local settings\temp



Select all files and delete. If you feel that’s extreme, just copy
them to a new location before deleting but remember that you can
delete them later. Try Excel again.



Possibly a bloated Excel.xlb file. Locate it using Start > Search >
For files and folders. It shouldn't be more than around 30K. It is
safe to delete this file but you'll lose existing toolbar
customizations, so unless it's bloated badly make a frequent backup.

And from Charles Williams:
http://www.decisionmodels.com/memlimits.htm

You may have troubles if RAM is less than 256 MB but 512 is best if
your workbooks are large.
Usually you can let Windows automatically control the size of your
swapfile, but if the hard disk containing your Windows system (usually
C drive) has very little space you may need to manually control the
size and location of your swapfile using the Windows Control Panel
(System Properties, Advanced Tab, Performance Settings, Memory
Useage). If you work with large workbooks your swapfile should be at
least 256MB and preferably 512MB to 1024MB.


-
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
To Norman Harker:

Thanks for Your help, it was very useful!
But I could not find the excel.xlb file, searching the entir
computer???

Regards
Georg Rokn
 
Hi gerok!

Try using *.xlb as the search string. But don't be too concerned as I
think that bloating of the xlb file was cured for Excel 2002 and
above. I haven't seen any firm reports to the contrary.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top