Home

This cell is inconsistent with the column formula error

Highlighted
George15
Occasional Visitor

Hello

 

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.

 

Suggestions?

1 Reply
Highlighted

Hi @George15

 

Hope you are well.

 

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

 

Cheers

Damien

 

 

Related Conversations
MSTeams Groups in outlook with macros disabled
ReadyorNot in Microsoft Teams on
0 Replies
Unknown Login Error
Alex_P3462 in Microsoft Teams on
0 Replies
Spelling Pop-Up Stuck on SharePoint List
aricornish in SharePoint on
0 Replies
Problem with OneDrive
esholder in OneDrive for Business on
5 Replies
Windows Admin Center 1910 SMEscripts
Padmin120 in Windows Admin Center on
0 Replies