At work, we have Excel 2002 (XP). When I type in numbers, it's in automatic
calculation. Provided as long as I'm not switching back and forth between
IE and Excel, for when Excel is calculating given it's in automatic mode, it
still allows me to type in a number in the next cell by stop calculation
until after I have pressed the enter key, then it restarts it's calculations
again.

At home, I have Excel 2003. Same type of setup, but the only difference,
once it starts calculating, it locks me out from putting any new numbers
until it's done calculating. This means, if I have any set of numbers to
put in, I have to put it into manual calculation, then enter the numbers in
the various cells, then put it back into automatic.

Yes, I could do the Alt-Ctrl-F9 after I put in the numbers, but why should I
have it setup that way otherwise. I have one file, which is my financial
file. Pressing the "F9" key by itself is not trustworthy as it rarely ever
calculates everything within the instance of Excel that the "F9" key is
pressed.

Here's my question: How can I get my Excel 2003 program give the same
calculation behavior as what the Excel 2002 at work does for me? Excel 2003
at home always locks me out for the duration of the calculation while the
only time when Excel 2002 locks me out through the duration of calculations
is when I am switching back and forth between IE and Excel, which doesn't
happen too often.


Technically, this financial file has gotten to the point that it really
needs to be converted to a DB program. The generic DB programs that's out
there are just that. They are so generic that I would only be able to do a
small portion of what I have within my Excel file. Access does have the
capacities that I would need, but it is a bear to have to deal setting up
cause for it to be setup and for it to work not only for keyboard users, but
also for mouse users while maintaining a stringent error checking procedure
in place, I had to create my own custom error checking program within
Access, unbind every single form and control in the FE file from the related
tables and fields respectively in the BE files, along with several other
issues that I have ran into within the Access Jet DB Engine, it's just a
bear to have to deal with it all. The Edit mode doesn't work too well on
the Access Jet Engine while in DAO mode, and the alternative mode of ADO, it
lacks the dynamic cursor keyset mode cause it's still going through the
Access Jet Engine, which in some cases makes it nearly impossible to deal
with in a multi-user environment. I can more than likely overlook this last
one for this file in particular given it would be just me for the most part
using the file, but for what I have went on to setup at work in Access, it's
been rough, but yet, in some ways, it's the only thing I been able to do as
our IT department doesn't seem to want to change anything in the main DB
program for supposed fear of upgrades, but yet, the upgrades hasn't even
taken place in the last 4 years minimally.

TIA

Ronald R. Dodge, Jr.
Master MOUS 2000