=TODAY() circular reference??

=TODAY() circular reference??

Didn't find your answer?

I have a developed a spreadsheet that i need to send out to colleagues which uses the function =today(). The cell that this function is in is not linked to anything else but it's causing a circular reference for some reason. I've tried Googling this and can see that other people have had the same issue but can't find any responses. My workbook is .xlsx in Excel 2007. Can anyone help please? I could live with it if it was just for my use but i don't want to publish it others likes this!  

Replies (3)

Please login or register to join the discussion.

avatar
By ACDWebb
16th Dec 2011 10:25

Do

other cells refer to it in calculations so that it is another cell referring to it that has the circular reference?

Thanks (0)
avatar
By User deleted
16th Dec 2011 12:50

Google - 'excel find circular reference' ...

http://answers.yahoo.com/question/index?qid=20071130165728AA9eT3E

 

Thanks (0)
avatar
By paulwakefield1
16th Dec 2011 13:24

Odd indeed

Apart from the above:

Have you tried the file on another computer?

Is Excel 2007 updated as far as possible?

Possible workaround: Does =NOW() give the same problem? If not, could you use that instead?

Long shot: Have you got a user defined function called TODAY?

Thanks (0)