refreshed excel doc with preserved formulas?

Hi - I have a refreshed report that I pull in daily/weekly from our HR system. How can I preserve the formuals within the template? After each refresh, all the formuals get wiped out. Any help is appreciated!

Thank you.

I think that what you need to do is to start the macro recorder.

And step through the spreadsheet and fill the formulas in each cell.

Stop the recorder.

Import your new data.

Run the Macro,

Your formulas should be reinstated.