Excel formula not working when exported

When I export a trial balance to excel I used to be able to add a formula but now it's showing a VALUE error. What has changed in the background that I am no longer able to add a formula to a trial balance exported to excel? Why have you removed this simple yet handy feature?

Would the formula you are adding be a vlookup or similar? Sometimes the looked-up value is not exactly the same as the value in the lookup range, which you can test by entering a formula like =a1=a23.

I had a similar thing happen where formulas just disappeared after export. What helped me was double-checking if MYOB is exporting as values only. If you’re rebuilding your spreadsheet, I’ve found the 101 Advanced Excel Formulas & Functions Examples https://www.myexcelonline.com/blog/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel/ pretty handy—it gives quick ways to remake formulas without starting from scratch every time. Saved me ages when things got wiped or didn’t copy right.