Application.Volatile not working as expected
 

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?

Try adding =now() somewhere on the sheet

--
Don Guillett
SalesAid Software

"Richards" wrote in message
...
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?

That did it. Thanks Don.

"Don Guillett" wrote:

Try adding =now() somewhere on the sheet

--
Don Guillett
SalesAid Software

"Richards" wrote in message
...
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?

glad to help

--
Don Guillett
SalesAid Software

"Richards" wrote in message
...

That did it. Thanks Don.

"Don Guillett" wrote:

Try adding =now() somewhere on the sheet

--
Don Guillett
SalesAid Software

"Richards" wrote in message
...
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?