the invoice attached will not calculate correctly.

blankestimate.xls

My Libre says the XLS file uses Macro(s) - written on VBA. Be aware that Libre only perfectly understands StarBasic. Ask a better question relating on that and not as a wiki, please.