Don't know the reason but just some FYI info:

The Workday function is part of the ATP in Excel versions <=11. The ATP
functions have been "rolled into" the main application for Excel 2007, thus
not requiring an add-in. Maybe that has something to do with it but that is
such an obvious compatibility issue that surely MS would have dealt with it.

Biff

"Jeff" wrote in message
...
When I open up a spreadsheet that was created in 2003 inside of 2007 that
has
the workday function in the sheet I get a #REF! error. The actual formula
changes to "=#REF!(Today(), -1, Holidays!A1:A5)". I also have made sure
that
the Analysis ToolPak Add-In is installed. In fact, I uninstalled the
add-in
and re-installed it to make sure that wasn't the issue. DOes anybody have
an
explination for this behavior or is this a bug?

Thanks - Jeff