Workbook with UDF needs "recompile" after opening with other Excel version

[Nico]

Hello,

I read "somewhere" that a workbook with a user definied function will
need some sort of recompilation the first time it is opened with an
other Excel version. I think the source mentioned that this was needed
for performance optimization. Does somebody have more information/urls
on this?
I've searched and searched but can't find the source again ;o(

We experience slow opening of a file with an heavy used UDF before any
VBA code is run.

Thank you.
Nico Saey

 

[Guest]

If it needs it, it will be done automatically.

 

[Nico]

Thanks Tom,

I also got some information on this url
http://www.decisionmodels.com/calcsecretsj.htm

But I'm still looking for some Microsoft details on this subject ;o)
Question example: If a save the workbook with the Excel 11 latest build
version under what conditions will the 'lower' Excel 11 build versions
(and Excel 10 other build versions) recalculate my workbook?

I understand that it will happen automatically and normally I like
things to be automatically. But in this case I would like to get one
file saved that will not need to be recompiled through all Excel
versions. ;o)

PS I don't know if it is the same sort of compilation that happens when
you click on Debug Compile or it is some sort of
Application.CalculateFull that happens in the Excel internals on the
opening of the file between Excel versions.

Greetings,
Nico

Tom Ogilvy schreef:

 

[Guest]

It may be both.

Excel 2002 instituted a different approach to recalculating that I would
assume would require a total recalculation. When moving between versions, I
believe there is a recalculation when opening anyway (just for that reason).

Compile has to do with converting source code into opcode for
interpretation.

I doubt you will come up with this "optimized" workbook or that it is even
necessary. Decisionmodels has the most information I have seen on
caclucation beyond what is in MSDN/Knowledge base. But then again, I haven't
done a lot of looking.

--
Regards,
Tom Ogilvy