Prev: Pulling Data from one worksheet into another
Next: Excel files take long time to open
From: Mike H on 17 Feb 2010 11:47
Hmmm,

I'm confused. email me the file to the address below with the obvious
changes to the address and I'll take a look

m.l.hughes at virginmedia.com
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Cam" wrote:

> Hi Mike,
>
> I did exactly what you suggested and it still didn't work.
> I have both Analysis Toolpak & Analysis Toolpak VBA selected.
>
> What else can I do? Thanks
>
> "Mike H" wrote:
>
> > Hi,
> >
> > As posted and with the ATP loaded your formula works fine so try this
> >
> > Check again you have loaded the correct ATP. You want the Analysis Toolpak
> > and not the Analysis Toolpak VBA
> >
> > Check the spelling of your formula and to be sure paste the one in from your
> > first post because we know that's correct.
> >
> > lastly select the cell with the formula and tap F2 and then press enter
> > --
> > Mike
> >
> > When competing hypotheses are otherwise equal, adopt the hypothesis that
> > introduces the fewest assumptions while still sufficiently answering the
> > question.
> >
> >
> > "Cam" wrote:
> >
> > > I did have ToolPak loaded from the add-in, but it didn't work.
> > >
> > > "Mike H" wrote:
> > >
> > > > Hi,
> > > >
> > > > Straight from E2003 help
> > > >
> > > > If this function is not available, and returns the #NAME? error, install and
> > > > load the Analysis ToolPak add-in.
> > > >
> > > > Tools - Addins and then do what help says
> > > > --
> > > > Mike
> > > >
> > > > When competing hypotheses are otherwise equal, adopt the hypothesis that
> > > > introduces the fewest assumptions while still sufficiently answering the
> > > > question.
> > > >
> > > >
> > > > "Cam" wrote:
> > > >
> > > > > Hello,
> > > > >
> > > > > Why does it returns "#NAME?" when I use =WORKDAY function in Excel 2003?
> > > > >
> > > > > My formula is =WORKDAY(D4,-B1,Holiday!A2:E109) where D4 is a date and B1 is
> > > > > the number of days.
> > > > >
> > > > > Any sugguestion, thank you.
From: Shaz on 19 Mar 2010 05:51
Did you guys solve this problem? I'm having the same issue. The cell will show #Value until i manually F2+enter in the cell. Once that is done, I won't have to do it again, until i close and restart the spreadsheet.

My formula is =Workday(today(),-2). Pretty standard. I use it everywhere. I've removed and readded in analysis toolpak and toolpak vba. When readding the formula will recalculate.

It seems to me that excel is not aware of the add-in.

---
frmsrcurl: http://msgroups.net/microsoft.public.excel.worksheet.functions/Workday-function-not-working
First  |  Prev  | 
Pages: 1 2
Prev: Pulling Data from one worksheet into another
Next: Excel files take long time to open