Forum Discussion
Today Function circular reference
I am using a simple =TODAY() in a cell that does nothing else but display today's date. I do use this (today's date) on other date calculations. Excel is giving me a CIRCULAR REFERENCE error identif...
LeeL365 Circular references are not errors, but they will trigger a warning as they are often unintended and may lead to incorrect calculations. Somewhere in your sheet, one or more cells contain formulae that are referencing, directly or indirectly, back to itself. Find those, and correct them.
Riny_van_Eekelen Thank you. I went through the trouble shooter for all the sheets in the work book and yet none were found. Going through each cell is not something anyone should have to go through. obviously something is amiss in the Microsoft coding. it is not the first thing I have found as they have acknowledged.