Error: Check that the cell references, range names, defined names and links to other wor..

Hi,

I have a very frustrating error:

"We found a problem with one or more formula references in this worksheet.

Check that the cell references, range names, defined names and links to other workbooks in your formulas are all correct.”

I have searched through the data and sometimes I delete certain cells and it saves fine but when I do it in my master with the same cells I then get the issue somewhere else.

How do I find whats causing the issue as it seems to be changing from one thing to the next?

On another post online someone says: “I finally found it, turns out that one my dynamic charts had a 0 in it and excel didn't like that” I too have a dynamic chart – but I am unsure what to look for?

It might be because the formulas on the Open FP&A BR Actions Log have "Y", not "Yes" in them.

In sheet "Open FP&A BR Actions Log" column "B" mentioned formula with "Y" instead "YES".

Formula:

Please Login or Register  to view this content.