M
msnyc07
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 FormulaMenu>Calculations>Manual is
3) Made sure all sheets were set to Manual as well since
ExcelSettings>Formula>Manual>Don'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/com...dg=microsoft.public.excel.worksheet.functions
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 FormulaMenu>Calculations>Manual is
3) Made sure all sheets were set to Manual as well since
ExcelSettings>Formula>Manual>Don'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/com...dg=microsoft.public.excel.worksheet.functions