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 :-(

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies