Formulas are ruined in a table because of calculated formula

Are you still using Excel 2010?

There are instructions at the top of the page explaining how to attach your sample workbook.

From your profile, which is clearly not up-to-date - please update it for us.

Sorry - I have never experienced the issue you are describing. The screenshot is NOT sufficient as I cannot see all of the formulae you say are getting messed up, nor can I test it here to see what you are seeing. And no, I cannot see the changes - I have no idea what it's supposed to look like!

If you want us to make guesses, then the screenshot will be enough, but I'm not going to speculate. Up to you.

You have provided a picture of a worksheet. You have said "In one table I have a column with the following values:" without stating which table you mean. You then say the values[formulas] are: "=M2, =M3, =M4, etc." but your picture doesn't show cells M2:M4 (etc). So, even if anyone were prepared to set up a simulation of your worksheet, they wouldn't know what they were trying to replicate.

It may well be a bug but there is no effective way of anyone confirming your suspicions, or coming up with a workaround, as there is no guarantee that the simulation would be accurate ... and that can waste a lot of everyone's time.

My impression was that it was a known bug..

I have attached the problematic excel file.
Please see the sheet ADD and cells B13:B18.

The values should be:

=D13
=D14
=D15
and etc..

Thanks for the help!

By the way, now the problem happens also when I open it on Desktop Excel.

I can confirm what you are seeing. However, if I correct the formulae and save the workbook, close it and re-open it, the formulae remain intact.

It is not a bug known to me - do you have evidence of its being widely reported?

Were the formulae correct when you attached the file? If not, please correct, save, close and attach before opening again.

I have just opened it on my iPad and it has opened with the formulae intact and working.

I just added a row of data to the app sheet and nothing has changed on the add sheet, so sorry, I can’t replicate your issue.

I mean that the formulae have not changed.

Originally Posted by whatever61

It seems to be a bug of AppSheet then and might be better to ask in their forum..

I don’t know it - is it an add in? Yes, it seems the fault lies with it and not Excel.

Let us know what you find out.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.