A bit more explanation:
the problem is caused by Excel doing a full calculation (all formulae) when
opening a workbook that was last calculated with a different version of the
calculation engine. doing Full calculation tries to recalculate the external
links/addin functions.
So if you can ALL use the same version of Excel and you full calculate the
workbook before saving it you should not have the problem.

If you can do it this way its probably a better solution than the registry
fix.

BTW the registry fix (originally made public by Jim Rech) should reference
11.0 rather than 9.0 for Excel 2003

Charles
______________________
Decision Models
FastExcel 2.3 now available
Name Manager 4.0 now available
www.DecisionModels.com

"Michael Hoffmann" <m.hoffmann AT compar.cc wrote in message
...
Hello Charles,

thanks for your fast reply.

Here are some suggestions:

- write some code that uses paste-special values to convert all the
external links to values and saveas the distributed version of the
workbook.

Last resort. I still hope for the setting...

- try using Excel 2003 to do a Full Calculation (ctr/alt/f9) before
saving and distributing to avoid the 'calculate when opening from a
different excel version' problem

Are you saying that this problem would be fixed with the sender and the
recipients using the same version of Excel?


- apply registry patch to all the recioients machimes (this does not
sound very practical)
Under: HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Ex cel\Options
create a new DWORD item named: FullCalcOnLoadOldFile and Leave its value
at the default of 0.

I think that's what I was looking for!

Thanks,

Michael Hoffmann