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!