Circular Reference with HYPERLINK and FORMULATEXT: why?

Hi Requin,

Any chance you could attach your workbook? I've just recreated what you have described and got no such circular reference.

Thanks,

---
Bernieburnham

Here it is (note: it's originally in German, hope it translates well).
In the lower left corner, my Excel says "Zirkelbezüge: B1", which means that there is a circular reference in cell B1.

Thanks for that.

Unfortunately when I open that file, it does not present any circular references. I'm guessing this is a stripped-down version of your original file, so I'm wondering whether the issue lies in there (i.e. somehow the formula in Basic!D12 links back to Sheet1!B1). Some things I can suggest:

1. Perform a full rebuild (CTRL + ALT + SHIFT + F9). Sometimes the status bar message for a circular reference lingers, even after the circular reference is resolved.
2. Delete the formulae on your primary worksheet (i.e.: Sheet1). Rebuild and see if the circular reference still exists. If so, then it's somewhere else in the workbook. If not, create a new sheet and add the Sheet1 formulae to that.
3. Change the destination of the link in Sheet1!A1 to an arbitrary cell on a new sheet. If that solves the problem, it is likely that Basic!D12 refers back to Sheet1!B1.
4. If you're still really struggling, I would suggest starting at Basic!D12 and work back through its precedants cell-by-cell to check if everything is how you would expect.

Sorry I can't be more helpful. Let me know if you find it or not.

Thank you very much! Can't try it out now, but will do it soon