Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
UDFs in worksheets with external data sources
Hi,
I have cells that call user defined functions in a database-linked worksheet. Refreshing the data causes some pretty irritating behaviour. When the old data gets deleted, the cells referencing the UDFs are recalculated. Because there's nothing in the cells passed as arguments to the UDFs, the UDFs return error strings. I can live with this. However, once the new data is loaded, the same cells are NOT recalculated. I have to force a recalculation by pressing CTRL-ALT-F9. Is there some event that occurs at the end of a database retrieve where I can code the worksheet to do a full recalculation? Cheers! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
UDFs in worksheets with external data sources
have you thought about using application.calculatefull at the end of the
database retrieval code? -- www.alignment-systems.com "Gyruss" wrote: Hi, I have cells that call user defined functions in a database-linked worksheet. Refreshing the data causes some pretty irritating behaviour. When the old data gets deleted, the cells referencing the UDFs are recalculated. Because there's nothing in the cells passed as arguments to the UDFs, the UDFs return error strings. I can live with this. However, once the new data is loaded, the same cells are NOT recalculated. I have to force a recalculation by pressing CTRL-ALT-F9. Is there some event that occurs at the end of a database retrieve where I can code the worksheet to do a full recalculation? Cheers! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing External data from various sources | Excel Discussion (Misc queries) | |||
external data from multiple sources | Excel Programming | |||
Why can't I edit my external data sources? | Links and Linking in Excel | |||
Why can't I edit my external data sources? | Excel Discussion (Misc queries) | |||
External data sources in Excell... | Excel Programming |