formula effects all dates in rest of worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello!
We change a date in one cell and all the other cells in sheet get
unrecognizable. The cell we change has this formula =SUM(U14+28) and when we
change the 28 to a 42 the reset of the cells go to this symbol...#NAME?
Any ideas why this is happening, and are there any options we need to check.

we are using Office 2003 on Windows XP SP2.

Thanks,
CC
 
What are the formulae in the cells that display the #NAME! error?

(Note that your SUM() is redundant - it just adds an unnecessary
function call. Better:

=U14+28

).
 
Thanks for the reply!

Here are some examples:
=WORKDAY(L21,-L$13,$A46:$A61)
=WORKDAY(L35,-L$13,$A46:$A61)
=WORKDAY(Q41,-Q$13,$A46:$A61)

hope that helps you out some....let me know if you need any more information!

Thanks,
CC
 
Maybe this........?

WORKDAY is an ATP function.

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.


Gord Dibben MS Excel MVP
 
Back
Top