Iliace;

I have been wondering if that might have something to do with it. When I
first installed XL2007, I added in the Analysis ToolPack, assuming that it
would be necessary (there was no warning that I should not). When I started
getting the problems, I checked the web and discovered that Networkdays() was
now a native function. I removed the TPA but the problems persist. I'm
thinking now that I should uninstall and reinstall Office 2007.

You say you haven't found a workaround - does that mean that you have also
experienced the problem?

Sean



"iliace" wrote:

This will happen with formulas using Analysis ToolPak functions,
because those are now built-in Excel functions without an add-in. I
haven't found a workaround, but then again, I hardly used ATP
worksheet functions prior to 2007.


On Jan 22, 8:30 pm, Sean wrote:
I have also just migrated to Excel 2007 and am experiencing the same
problem. Any formula using Networkdays() is replaced with =#N/A. These
formulae always worked in 2003 but now result in a "File Error: Data may have
been lost" message when I open the file in 2007, along with all the
Networkdays() formulae being replaced with =#N/A. There are several threads
on this topic, but so far no answers.

Sean

"Stan Brown" wrote:
Fri, 23 Nov 2007 11:40:01 -0800 from Alan Smith
:
when I opened the sheet this morning (in
compatability mode initially), all the formulas had been replaced with =#N/A.

I suspect you have a #NA somewhere in a precedent cell. Either trace
the logic back through the cells and arrays that are used in your
formulas, or use the Formula Auditing feature.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/