Hi Kush, The method explained below will stop annoying you because the Internet Explorer 4.0, 5.0, 6, 7, and 8 time-out is based on the number of script statements executed, the time-out dialog box will not display during ActiveX control or database-access delays. Endless loops in script will still be detected.
Caution: Take a backup of registry before committing this change. 1. To change this time-out value in Internet Explorer 4.0, 5.0, 6, 7, or 8, follow these steps: Using a Registry Editor such as Regedt32.exe, open this key: HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\Styles *Note If the Styles key is not present, create a new key that is called Styles. 2. Create a new DWORD value called "MaxScriptStatements" under this key and set the value to the desired number of script statements. If you are unsure of what value you need to set this to, you can set it to a DWORD value of 0xFFFFFFFF to completely avoid the dialog. For details Refer to MicroSoft Knowledge Base : http://support.microsoft.com/kb/175500 ________________________________________ Thanks & Regards Ashish Jain McKinsey India Knowledge Center (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.openexcel.com ________________________________________ On Oct 14, 9:02 am, kush sharma <[email protected]> wrote: > Heloo Everyone, > > I have this problem whenever i try to create a refreshable web query. As > soon as i eneter the link in the web address bar the window appears which > asks something like "this page contains a script, do you wish to continue?" > now i do click yes, but this message appears again so fast that i cannot get > past it...is there any particular solution to this thing or any excel > setting that i have to do? > > I'd be glad to have some good response. > -- > * > Regards > > Kushlesh Sharma > * -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to [email protected] <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
