Application.Volatile not working as expected

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

User functions not automatically invoked in Excel 2000, but are i. 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Having a macro/function available in new spreadsheets 1
Call Application.Volatile(True) NOT WORKING 1
Application.Volatile Not Working Timely 2
Editing cell names 1
2003 Macro in a 2007 World 1
Quote Marks Question 2

Back
Top