energman58
Well-known Member
- Joined
- Oct 25, 2010
- Messages
- 553
Hello
Has anyone come across/got a solution for the following strange behaviour in Excel 2007?
I have a formula that is not circular but triggers the circular reference warning when I open the workbook. The offending formula includes INDIRECT (I know I know - but it is the easiest way to do this) if that is significant. Also there were a number of circular errors in the spreadsheet when I got it (from someone else) but I fixed those - the formula it is highlighting now is on a new sheet which I added so I can't blame them!
The formula calculates correctly - it just throws the error message.
All suggestions gratefully received!
Has anyone come across/got a solution for the following strange behaviour in Excel 2007?
I have a formula that is not circular but triggers the circular reference warning when I open the workbook. The offending formula includes INDIRECT (I know I know - but it is the easiest way to do this) if that is significant. Also there were a number of circular errors in the spreadsheet when I got it (from someone else) but I fixed those - the formula it is highlighting now is on a new sheet which I added so I can't blame them!
The formula calculates correctly - it just throws the error message.
All suggestions gratefully received!