Share via

Excel Sharepoint file formulas stopped working in browser

Andrew M 0 Reputation points
2023-04-12T17:04:22.0833333+00:00

Hello there, I use an excel file where there are several tabs used by multiple users at once, we have the users do this in the SharePoint browser (see below photo). The first 4 columns have formulas in them and have worked fine for the past month since we implemented this file. A few days ago the formulas stopped working in all tabs of the file. I checked that iterative & auto calculations were still active and they were. From there I opened the file in the Excel App itself and all formulas worked fine populating the first 4 columns. User's image

What I don't want to do is have several users open the Excel App and input data there as it will cause a whole lot of confusion, we don't want several copies of the file saved either.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,797 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emily Du-MSFT 44,311 Reputation points Microsoft Vendor
    2023-04-13T02:01:16.7666667+00:00

    Excel Online is currently not supported in the Q&A forum.

    Please start a new discussion via the Answer Community so that you can get dedicated support on this issue.

    Thank you for your understanding.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments