Share via

Table formulas not working

Anonymous
2022-03-15T12:39:29+00:00

Good Morning,

I have the following dashboard that displays weekly wellness results.

I export the results from the Mindbody app to Excel. I then delete the columns not needed, copy and paste the to the right of the dashboard as shown below.

As you can see from the top figure the formulas are not reading the data as the cell values are all zero. This dashboard has been working fine until yesterday. I've tried everything I can think of. I appreciate your assistance with this problem.

Kind Regards,

Andrew

Microsoft 365 and Office | Excel | For home | Windows

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
Answer accepted by question author
  1. Anonymous
    2022-03-15T17:24:00+00:00

    Hi Andre,

    Thank you for responding I have solved the problem. The location cell value in the CVS file I was referencing was changed without my knowledge so my formula was returning zero.

    Thank you kindly for helping,

    Andrew

    0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-03-15T15:35:18+00:00

    What formulas are you using? And in which cells?

    0 comments
  2. Anonymous
    2022-03-15T17:02:01+00:00

    Hi

    My name is André. I am an independent consultant.

    Can you paste here one of the formulas that is not working?

    In your image it is not clear which formula you are using

    Answer here so I can continue helping you.

    André.

    0 comments
  3. Anonymous
    2022-03-15T17:23:11+00:00

    Bernie,

    Thank you for responding I have solved the problem. The location cell value in the CVS file I was referencing was changed without my knowledge so my formula was returning zero.

    Thank you kindly for helping,

    Andrew

    0 comments
  4. Anonymous
    2022-03-15T17:31:27+00:00

    It's always a pleasure to help in any way, I'll close the topic here, so that your case can help other people with the same question.

    Good work for you.

    André

    0 comments