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.