Currently I use a function to put last month's date in. In cell A1, I have:

=+TODAY()

then in cell A2 I have:

=EOMONTH(A1,-1)

What this result gives me is Last month. I use this for my schedules in reference to my financial statements. It automatically puts last month's date in.

However I am working partially on my desktop and partially on a work server. However whenever I go to open the file on the server it asks me to update links, when I click yes, it gives me an error

it tries to open a link to D:/program files/microsoft office/office 11/library/Analysis then the file name is ATPVBAEN.XLA

This never use to happen but just started happening. Anyone have a clue or ideas? It screws up the EO month function.