| Home > Forum Home > Presenting and Reporting Data > Unblock Excel | Share |
Unblock Excel
Excel Help for Unblock Excel in Presenting and Reporting Data
| Forum Topic | Post Reply Login |
Unblock Excel | Rate this: (3/5 from 1 vote) |
 | Hi all. I have an excel file with some cells containing Hypertextual URL links. These links are opened by a macro but sometimes the internet site is slow because it is down or in overload and excel crashes. I try pressing esc button but it doesn't work, the screen become white and everything stops. I was arguing if there is a way to unblock excel in these cases or maybe a code that I can insert in the macro so that it stops the loop after 10 seconds. Thank you __________________ http://www.giftideashop.net/ - http://www.idee-regalo.biz/ | |
| Posted by ghisirds on | ||
| Replies - Displaying 1 to 2 of 2 | Order Replies By: Most Recent | Chronological | Highest Rated |
| Rate this: (3/5 from 1 vote) To do this task you will need a macro. You will have to initiate the hyperlink from within the macro so that you can count the time it takes to load. You will need to include code that can check the browser address so that it matches partof your hyperlink. I say this because most sites change the url by adding extrabits that may contradict your original link. If there is no match for more that 5 seconds then range("A1").select This might redirect the attention back to Excel. I haven't tested this yet as it will require some nail-biting, hair-pulling, chain-smoking coding. |
| Posted by excelmarksway on |
 | Rate this: (4/5 from 2 votes) 1. You must have renamed the hyperlinked worksheet file name 2. sudden excel worksheet closure You try this solution: • First of all open your Excel Workbook ->Go to File->Options->Advanced • scrolling down to this advanced page you will get General tab, tap to it. Now hit the Web Options. • A Window of “Web Options” pops-up on your screen • On this Web Options dialog box, tap on Files tab and unselect the “Update Links on save” box • Click OK button to save changes. |
| http://www.repairmsexcel.com/ | |
| Posted by edwards142 on |
| Displaying page 1 of 1 |
| Find relevant Excel templates and add-ins for Unblock Excel in the Excel Business Solutions Directory |