Forum Discussion
Time formula error
1) Such alert is for the Tables only. Table assumes if the formula is used, that's the same formula for all cells of the column, and it's populated automatically with Table size changing. That's one of the main reasons why use Tables and not ranges. One column - one formula.
2) Excel "remembers" initial formula for the column and gives the alert if in some cells of the column formula differs from this initial one.
3) Thus that's Table-specific alert, you have no such outside the Table.
4) To fix - select the column and Del. Other words delete everything from it. Type any value, not formula, in any cell of the column (to avoid autofill). After that enter formulas into the cells, remove initial value.
It'll be no alert this time since there was no initial formula to "remember" for the column.
Please check in attached file.
That has been my issue, I "ignore this error" but it keeps coming back again as soon as I go to the next line.
I haven't copied and pasted it from the previous column, I enter it in separately every time (I know there's probably a better way to do it having it automated or something but I'm still getting my head around everything)
I was playing around with it last night and I noticed that when I did it outside of the table it worked no problem, no issues at all with the flags or anything, that's why I was thinking it had something to do with the table. (I have attached another sample)
But I will definitely have a look at that link you sent through, thank you so much for that SergeiBaklan
1) Such alert is for the Tables only. Table assumes if the formula is used, that's the same formula for all cells of the column, and it's populated automatically with Table size changing. That's one of the main reasons why use Tables and not ranges. One column - one formula.
2) Excel "remembers" initial formula for the column and gives the alert if in some cells of the column formula differs from this initial one.
3) Thus that's Table-specific alert, you have no such outside the Table.
4) To fix - select the column and Del. Other words delete everything from it. Type any value, not formula, in any cell of the column (to avoid autofill). After that enter formulas into the cells, remove initial value.
It'll be no alert this time since there was no initial formula to "remember" for the column.
Please check in attached file.
OMG thank you so much SergeiBaklan
It's worked, that is a huge relief. It's been frustrating me for quite some time and I never thought to sign up to a community like this, so thank you so much for you help.