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
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
description for autoplay blocking in settings page
HotCakeX in Discussions on
8 Replies