I am at my wits end with Excel, and with this issue in particular.

First Excel crashes and 'restores' my extensive 100 sheet 50.000 record
worksheet by removing indents from every record. Indents are criticial as
they determine relationships between the records for later parsing.

Fortunately I ran a script that derived the Indent in another column.

However every time I add a record it recalculates everything to zero (due to
it's prior crash)

So I turned calculate to Manual. That means me, the human being, the
customer, the client manually tells the program, the computer when to
calculate.

So every time I run my parse Macro the formulas recalculate anyway reducing
me back to useless data.

Manual is manual. Manual is ME. I couldn't care less what Excel wants to do.

My reply to your previous post...

Their is a check box just below the option button for manual calculation. It
is Recalculate Before Save. If you do not want it to recalculate before save
just uncheck the box.


Check out this link for posting etiquette...
http://www.cpearson.com/excel/HintsA...roupUsers.aspx
--
HTH...

Jim Thomlinson


"msnyc07" wrote:

I am at my wits end with Excel, and with this issue in particular.

First Excel crashes and 'restores' my extensive 100 sheet 50.000 record
worksheet by removing indents from every record. Indents are criticial as
they determine relationships between the records for later parsing.

Fortunately I ran a script that derived the Indent in another column.

However every time I add a record it recalculates everything to zero (due to
it's prior crash)

So I turned calculate to Manual. That means me, the human being, the
customer, the client manually tells the program, the computer when to
calculate.

So every time I run my parse Macro the formulas recalculate anyway reducing
me back to useless data.

Manual is manual. Manual is ME. I couldn't care less what Excel wants to do.

Thanks for the assist.

I checked the 'etiquette' and did not 'rant' against MS, I expressed my
problem and my frustration. I am sure other users get just as frustrated
with the application as I do. Note that 'Recalculate Before Save' is not on
the FormulasCalculation Options Menu but buried in settingsformula. How
would a user know this if they just went to the area where the Calculation
Settings are? Presumably if on the options menu it says 'Manual' AND there is
no 'Recalculate Before Save' toggle a normal person will assume Manual means
just that and not even think to dig into the application settings to see if
there are further options. This IS bad programming and sorry to save one in
a long line of items that has cause tremendous frustration. Sorry to add a
rant to my 'question' but these are the types of things that should be
addressed way way back (by Microsoft, not you) and not cause users
hours/days/weeks/years of lost work and/or frustration.

That said, I thank you very much for the reply. I did post a less
vituperative version earlier on.

"Jim Thomlinson" wrote:

My reply to your previous post...

Their is a check box just below the option button for manual calculation. It
is Recalculate Before Save. If you do not want it to recalculate before save
just uncheck the box.


Check out this link for posting etiquette...
http://www.cpearson.com/excel/HintsA...roupUsers.aspx
--
HTH...

Jim Thomlinson


"msnyc07" wrote:

I am at my wits end with Excel, and with this issue in particular.

First Excel crashes and 'restores' my extensive 100 sheet 50.000 record
worksheet by removing indents from every record. Indents are criticial as
they determine relationships between the records for later parsing.

Fortunately I ran a script that derived the Indent in another column.

However every time I add a record it recalculates everything to zero (due to
it's prior crash)

So I turned calculate to Manual. That means me, the human being, the
customer, the client manually tells the program, the computer when to
calculate.

So every time I run my parse Macro the formulas recalculate anyway reducing
me back to useless data.

Manual is manual. Manual is ME. I couldn't care less what Excel wants to do.

Hey no worries... As for the Rant whatever... Makes no difference to me. My
issue was that I don't like multi-posts. It gets really confusing when there
are a couple of threads of discussion going on the same issue. The question
gets solved in one thread while someone keeps working on the other thread.

Glad that that worked out for you and happy that you read the page for new
posters. Makes answering questions a lot easier.
--
HTH...

Jim Thomlinson


"msnyc07" wrote:

Thanks for the assist.

I checked the 'etiquette' and did not 'rant' against MS, I expressed my
problem and my frustration. I am sure other users get just as frustrated
with the application as I do. Note that 'Recalculate Before Save' is not on
the FormulasCalculation Options Menu but buried in settingsformula. How
would a user know this if they just went to the area where the Calculation
Settings are? Presumably if on the options menu it says 'Manual' AND there is
no 'Recalculate Before Save' toggle a normal person will assume Manual means
just that and not even think to dig into the application settings to see if
there are further options. This IS bad programming and sorry to save one in
a long line of items that has cause tremendous frustration. Sorry to add a
rant to my 'question' but these are the types of things that should be
addressed way way back (by Microsoft, not you) and not cause users
hours/days/weeks/years of lost work and/or frustration.

That said, I thank you very much for the reply. I did post a less
vituperative version earlier on.

"Jim Thomlinson" wrote:

My reply to your previous post...

Their is a check box just below the option button for manual calculation. It
is Recalculate Before Save. If you do not want it to recalculate before save
just uncheck the box.


Check out this link for posting etiquette...
http://www.cpearson.com/excel/HintsA...roupUsers.aspx
--
HTH...

Jim Thomlinson


"msnyc07" wrote:

I am at my wits end with Excel, and with this issue in particular.

First Excel crashes and 'restores' my extensive 100 sheet 50.000 record
worksheet by removing indents from every record. Indents are criticial as
they determine relationships between the records for later parsing.

Fortunately I ran a script that derived the Indent in another column.

However every time I add a record it recalculates everything to zero (due to
it's prior crash)

So I turned calculate to Manual. That means me, the human being, the
customer, the client manually tells the program, the computer when to
calculate.

So every time I run my parse Macro the formulas recalculate anyway reducing
me back to useless data.

Manual is manual. Manual is ME. I couldn't care less what Excel wants to do.