Share via

Excel document with formulas not working in TEAMS

Anonymous
2022-11-25T10:42:46+00:00

HI, I have an excel file that the team are using via TEAMS which has many formulas. The values from the formulas constantly change to incorrect values in different rows. Does anyone know how to stop this please? Many thanks in advance

Microsoft Teams | Microsoft Teams for business | Files | Save files

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-11-25T11:25:18+00:00

    Hi, SUE

    Thanks for reaching out.
    My name is God'swill, I'll be happy to help you today.

    For some reason the default in Teams for "Calculation Options" under the "Formula" tab might be set to manual/automatic.
    Try changing is to automatic if it's on manual or the other way round, once it is changed it will work as indented.

    Please be sure to let me know if you need more help as I'll be glad to do so.

    Regards...
    God'sWill

    3 people found this answer helpful.
    0 comments