Afternoon,
I am having a problem in a fairly complex excel spreadsheet in that about half the time I open it I get a Circular Reference warning for a TODAY() function that I have on the summary page. Sometimes I can close the book and re-open it and it goes away but other times it just keeps coming up.
It's really annoying as it means when I change anything I have to then cancel the warning.
Does anyone have any idea why this might be happening? What I can do to stop it?
Thanks,
Alice
Bookmarks