Calculate formula, circular ref. issue...

[albertc30]

Hi everyone.

This error is doing my head in.

I created another tab on my workbook and entered a few formulas and advanced filters to return say unique not repeting values.

Since then, I am getting this annoying error. There are no formulas on the new sheet. Inclusive I deleted the sheet but the issue still persists.

How on earth am I going to find this if the circular reference doesn't even show as per ussual?

Any help is much appreciated.

Thank you.

Albert

 

[jasonb75]

Check for an unknown named range. I could be wrong but I'm fairly sure that I remember it being the cause of a similar problem in another thread.

 

[albertc30]

Check for an unknown named range. I could be wrong but I'm fairly sure that I remember it being the cause of a similar problem in another thread.

Oh mate, in the end I went back to an older version and only lost 15 minutes of work.

It was doing my head in.

Thanks for helping and be safe mate.

Albert