This cell is inconsistent with the column formula error

Occasional Visitor



This forum has been useful for me, so thank you to this community, but this is my first time posting...


I am working with an Excel table via Office 365 that is fed by Forms.  In one of my columns, I get the error that says "This cell is inconsistent with the column formula."  I have opened the file in Desktop Excel, copied down the formula which corrected the issue, saved, and resumed working in Office 365.  When I return to the file later, the "correction" didn't save down the column with new added data from Forms and the same error message appears.



1 Reply

Hi @George15


Hope you are well.


I would expect new Forms responses to overwrite any changes you have made to the formula.






Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
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
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies