hello I have an excel 2007 workbook, which contains a number of external data ranges. The query definition for these external data ranges is the local path to an html file (eg, file:///D:/localfiles/filename.html). Each html files contains a data table. This works perfectly most of the time. (And there is a reason we are stuck using the html format)
The workbook is set up to auto-refresh all queries every five minutes. I have a separate function that updates the content of the html files. Again, the system basically works, almost all the time. The trick is the almost -- about one of 20 times that the excel file opens, I get a "failed to refresh data range: 'range_name'. continue to refresh all?" And the program sits and hangs until I respond. This is a showstopper because these files must be able to run automatically, at all hours, without human intervention. When this happens, I can verify that the subject html file does exist, and that it does have content. The format and fields of the content are exactly the same when it does not work as they are when it does work. Does anyone know how to troubleshoot this? Or any advice specific to this challenge? (again, I am stuck using these html files and this general approach of excel auto-refresh of external data ranges.) Thanks very much in advance. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
