Hi,

I am copying my sheets and changing there names. For instance, I have sheets
in this order:

May 1 - Day and May 1 - Night. May 1 - Night has formula connecting it to
May 1 - Day, but when I try to update the formla, excel does not allow me.
instead, a window opens asking me to select a file I want to update.

Can anyone help me?