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

  • 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 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?
 
Hi, Richards.

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

Sprinks
 
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

Application.Volatile not working as expected 3
Excel Data Transfer Issue (strange situation) 1
A2003 bringing in data from an Excel spreadsheet 1
Close specific Excel spreadsheet using VB Code in Access 1
Access or Excel Reports 7
Excel Import External Data by Date Automatically 0
Persistent Connection Excel 1
Best method / software for graphical output from dynamic excel data 0

Back
Top