FWIW, I've been using 2007 for quite awhile, both at home and at work.
It will very occasionally stop working for me. BUT ... most times I'm just impatient.
2007 has a million+ rows and 16k+ columns, so if you ask it to do something that affect a gazillion cells, it might look like it stuck, but really could be in a tight loop.
Under Options, Advanced there's
Out of the box, it's 33554 and I assume it's (in thousands) so that could be a lot of cells. Maybe crank that down ans seeAlert the user when a potentially time consuming operation occurs Select if you want to be notified when an operation affects a large number of cells and may take a long time to process.
- When this number of cells (in thousands) is affected Lets you specify the maximum number of cells that are affected by an operation without being notified. If more cells than the maximum number of cells are affected, you are notified.
Even simple things that I was used to doing in 2003 like selecting a column and appling formatting or something like that, can be tricky with 2007, since now it's not 65K cells, but 1M cells
Just some thoughts
Paul




