Dec 18 2018 09:35 AM
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?
Dec 18 2018 03:06 PM
Hi @George15
Hope you are well.
I would expect new Forms responses to overwrite any changes you have made to the formula.
Cheers
Damien