| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
User created function not "updating"
I have a user created function that I run over data pulled in from a
external html source. The function works properly until I refresh this external html data at which point the function now returns #VALUE! Once I have "updated" the cell (Press F2 and then Enter) it seems to reinitialise and all is fine. Can I add something to the function or perhaps the data query to fix this? Thanks. Richard |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
User created function not "updating"
Does your function contains the line
Application.Volatile (as first line!)... greetz "Richard Edwards" schreef in bericht ... I have a user created function that I run over data pulled in from a external html source. The function works properly until I refresh this external html data at which point the function now returns #VALUE! Once I have "updated" the cell (Press F2 and then Enter) it seems to reinitialise and all is fine. Can I add something to the function or perhaps the data query to fix this? Thanks. Richard |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
User created function not "updating"
it does now - sorry - i should have known that!
is there a way of turning this off? a little too much calculation going on now.... "Frederik" wrote in message ... Does your function contains the line Application.Volatile (as first line!)... greetz "Richard Edwards" schreef in bericht ... I have a user created function that I run over data pulled in from a external html source. The function works properly until I refresh this external html data at which point the function now returns #VALUE! Once I have "updated" the cell (Press F2 and then Enter) it seems to reinitialise and all is fine. Can I add something to the function or perhaps the data query to fix this? Thanks. Richard |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
User created function not "updating"
Maybe something with...
Application.Calculation=xlManual or Application.ScreenUpdating=False (so you will not SEE that Excel is recalculating) <code Application.ScreenUpdating=True greetz "Richard Edwards" schreef in bericht ... it does now - sorry - i should have known that! is there a way of turning this off? a little too much calculation going on now.... "Frederik" wrote in message ... Does your function contains the line Application.Volatile (as first line!)... greetz "Richard Edwards" schreef in bericht ... I have a user created function that I run over data pulled in from a external html source. The function works properly until I refresh this external html data at which point the function now returns #VALUE! Once I have "updated" the cell (Press F2 and then Enter) it seems to reinitialise and all is fine. Can I add something to the function or perhaps the data query to fix this? Thanks. Richard |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
| Created date in "General" tape and "Statistics" tape | Excel Discussion (Misc queries) | |||
| Is there a "last saved on date/user" macro/function for Excel 2003 | Excel Discussion (Misc queries) | |||
| Problems updating shared documents which used "Lookup" function | Excel Discussion (Misc queries) | |||
| Showing "Created by User, Date, Time" in Footer | Excel Discussion (Misc queries) | |||
Linear Mode
