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 spreadsheet 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?