The correct answer is that QB Online does not send formulas to Excel, but instead a static report of numbers. There isn't a way to change what it does. This is basic product knowledge.
I just checked mine again, it does export the formula's, at least on a P&L report I ran
I agree with updating and/or repairing excel though
