I won't bother ranting again since I'll be accused of not knowing what I am
doing.

1) Set my sheet in Formulas Menu to Manual Calculation (which should
logically and programtically and intuitively be enough)

2) Went into Excel Settings, Formulas Menu and also set THAT to Manual AND
toggled off 'Calculate on Save' i.e ACTUALLY manual vs Semi-Automatic which
is in fact what FormulaMenuCalculationsManual is

3) Made sure all sheets were set to Manual as well since
ExcelSettingsFormulaManualDon't Calculate on Save means 'Unless the first
document opened is set to Automatic in which case assume that despite the
users clear indication they want Manual Manual they want to overide that just
because they open an earlier document'

In the middle of VBA code on ANOTHER sheet it processed all of the formulas
on all the open sheets anyway AND crashed (yet again, semi-daily crashes are
the norm)

This is unacceptable. I am quite sure you know other users run into issues
so please fix it.

While you are at it:

Manual should mean Manual and if/when it is not it should be clear it is
not. Automatic/Manual-Calculate on Save/Manual should be the names if that
is in fact their function.

Freeze Panes should Freeze Panes otherwise it is only Freeze the way ice
cubes are when you take them out of the freezer.

Select All should Select All, if you meant Select Some Some of the Time then
make it another function i.e. Select All / Select Range/Some

None of the above is about MY lack of experience/knowledge of the program
unless you truly believe that users should suffer through loss of data/time
in order to find out that Functions don't actually perform the way they do
everywhere else in the world and/or the way their name clearly indicates they
should.

While I am at it:

Since Excel crashes soooo much the Document Recovery Pane should be more
useful:

We should be able to sort on date/name

If we scroll down and recover a file we shouldn't be scrolled back to the
top to go find where we were before.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

I don't think there is anything to fix: it works as designed (of course the
design could be improved ...)

Calculation mode is an application session level setting: it does not
operate at worksheet or workbook level.
Thats why it gets set by the first workbook opened.

If Excel is in Manual Calculation mode then anytime VBA executes
Application.Calculate or Calculate or Application.Calculation=xlAutomatic,
Excel will recalculate all the formulae that have been changed or depend on
a changed or volatile cell or are volatile, and their dependents, on all
the worksheets in all the open workbooks.

Charles Williams
Decision Models

"msnyc07" wrote in message
...
I won't bother ranting again since I'll be accused of not knowing what I am
doing.

1) Set my sheet in Formulas Menu to Manual Calculation (which should
logically and programtically and intuitively be enough)

2) Went into Excel Settings, Formulas Menu and also set THAT to Manual AND
toggled off 'Calculate on Save' i.e ACTUALLY manual vs Semi-Automatic
which
is in fact what FormulaMenuCalculationsManual is

3) Made sure all sheets were set to Manual as well since
ExcelSettingsFormulaManualDon't Calculate on Save means 'Unless the
first
document opened is set to Automatic in which case assume that despite the
users clear indication they want Manual Manual they want to overide that
just
because they open an earlier document'

In the middle of VBA code on ANOTHER sheet it processed all of the
formulas
on all the open sheets anyway AND crashed (yet again, semi-daily crashes
are
the norm)

This is unacceptable. I am quite sure you know other users run into
issues
so please fix it.

While you are at it:

Manual should mean Manual and if/when it is not it should be clear it is
not. Automatic/Manual-Calculate on Save/Manual should be the names if
that
is in fact their function.

Freeze Panes should Freeze Panes otherwise it is only Freeze the way ice
cubes are when you take them out of the freezer.

Select All should Select All, if you meant Select Some Some of the Time
then
make it another function i.e. Select All / Select Range/Some

None of the above is about MY lack of experience/knowledge of the program
unless you truly believe that users should suffer through loss of
data/time
in order to find out that Functions don't actually perform the way they do
everywhere else in the world and/or the way their name clearly indicates
they
should.

While I am at it:

Since Excel crashes soooo much the Document Recovery Pane should be more
useful:

We should be able to sort on date/name

If we scroll down and recover a file we shouldn't be scrolled back to the
top to go find where we were before.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions