Home

losing formulas in excel

pclarkey-1978
New Contributor

so i have created a query in microsoft access via excel so it auto refreshes based on data entry fields such as customer name. I then have formula fields next to some of the returned columns, such as qty ordered - qty received, however since having excel 365, whenever there are no records it replaces all my formulas with the column heading names, it never used to do this, it would simply return a "-" or "#n/a" on any formula cells, now i have lost all the formulas and currently having to keep retyping them out. please help, there are many reports and many queries with the same issue. i have attached a screenshot for reference

1 Reply

wow, really.. no replies :-(