I have an Excel workbook with various sheets. 2 sheets are of importance for this issue: 'Extract' and 'SalesExportTable'. The 'SalesExportTable' gets refreshed via a PowerQuery that pulls data from a csv file.

'Extract' makes formula references to sheet 'SalesExportTable'.

The issue I'm getting is some formulas in 'Extract' that make reference to 'SalesExportTable' get broken when the data gets refreshed.

The easy fix is to rebuild the formulas in 'Extract' but I'd like to fix this permanently. Why do these formulas break?