User functions not automatically invoked in Excel 2000, but are i.

R

Richards

I have a spreadsheet with some user defined VBA functions. If I bring up the
spreadsheet by itself, everything works fine. If I load the subject
spreadsheet from a "rollup" spreadsheet, (uses the subject spreadsheet and
others like it as input), the user defined VBA functions are not being run -
when using Excel 2000. If I use the same spreadsheets and run it under Excel
2002, the user functions do get run before the "rollup" spreadsheet starts
reading data off the subject. (Functions are defined as
"Application.Volatile". Why? Is there a work around?
 
S

Sprinks

Hi, Richards.

You've posted this to the Access Newsgroup. They can help you if you repost
it over at the Excel one.

Sprinks
 
G

goodguy

Sprinks said:
Hi, Richards.

You've posted this to the Access Newsgroup. They can help you if you
repost
it over at the Excel one.

Sprinks

:
-
I have a spreadsheet with some user defined VBA functions. If I bring
up the
spreadsheet by itself, everything works fine. If I load the subject
spreadsheet from a "rollup" spreadsheet, (uses the subject spreadsheet
and
others like it as input), the user defined VBA functions are not being
run -
when using Excel 2000. If I use the same spreadsheets and run it
under Excel
2002, the user functions do get run before the "rollup" spreadsheet
starts
reading data off the subject. (Functions are defined as
"Application.Volatile". Why? Is there a work around?-
Click to expand...

See Microsoft KB article 327006 " External links may update when you
open a file that was last saved in a previous version of Excel"
 
Top