formula effects all dates in rest of worksheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

VIT - 18 Jun 2007 16:22 GMT

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

Reply to this Message

JE McGimpsey - 18 Jun 2007 16:31 GMT

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

).

> Hello!
> We change a date in one cell and all the other cells in sheet get
[quoted text clipped - 6 lines]
> Thanks,
> CC

Reply to this Message

VIT - 18 Jun 2007 22:32 GMT

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

> What are the formulae in the cells that display the #NAME! error?
>
[quoted text clipped - 15 lines]
> > Thanks,
> > CC

Reply to this Message

Gord Dibben - 18 Jun 2007 22:40 GMT

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

>Thanks for the reply!
>
[quoted text clipped - 27 lines]
>> > Thanks,
>> > CC

Reply to this Message

Rate this thread: