I've created a report using the accounting software Quickbooks which I subsequently exported into a CSV file. I then created a file in excel so that every time the report is run in Quickbooks and exported, it automatically updates the excel file (with use of the refresh button).

The problem I'm having is with linking formulas to the the excel file that is getting updated. When the excel file is refreshed some of the formulas get broken depending on if there are a greater or fewer number of rows run in the specific iteration of the report. Can anyone please help me with this problem? Thanks!