| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#3
|
|||
|
|||
|
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? |
|
#4
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF Function not working | Excel Discussion (Misc queries) | |||
| Working with mac addresses | Excel Discussion (Misc queries) | |||
| how do I adjust working calendar (6 day work week) in excel that . | Excel Worksheet Functions | |||
| Worksheet Buttons (Save, Save As, Cut, Paste, etc.) Not Working | Excel Worksheet Functions | |||
| Setting Major tick to none on charts is not working, is it a bug? | Charts and Charting in Excel | |||
Linear Mode
