LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 12
Default 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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Text "comparison" operator for "contains" used in an "IF" Function Pawaso Excel Worksheet Functions 4 April 4th 23 11:35 AM
Created date in "General" tape and "Statistics" tape Winnie Excel Discussion (Misc queries) 1 January 5th 07 02:43 PM
Is there a "last saved on date/user" macro/function for Excel 2003 Zliz Excel Discussion (Misc queries) 2 January 2nd 07 10:12 PM
Problems updating shared documents which used "Lookup" function Yeam69 Excel Discussion (Misc queries) 0 June 21st 06 08:42 AM
Showing "Created by User, Date, Time" in Footer Mark Plaideau Excel Discussion (Misc queries) 0 April 9th 06 11:29 PM


All times are GMT +1. The time now is 05:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"