Nieck;
Unfortunately, no. What is happening is that when I open the file, I get the
message: "File Error: Some Data may have been Lost" and when I look at the
offending cells I see the numbers (values) that should be there, i.e.
everything looks OK. But if I look at the formula in each cell, it has been
changed to: "=#N/A". After I press Ctrl-Alt-Shft-F9 all the visible values
change to "#N/A". So, although Ctrl-Alt-Shft-F9 doesn't fix it, I am glad you
mentioned it because it's a quicker way of finding where the problems are.
Sean


"Niek Otten" wrote:

I assume that rebuilding the formula chain will solve the problem; CTRL+ALT+SHIFT+F9

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Sean" wrote in message ...
| 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/
|
|