Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel unblock

ResolvedVersion 2003

Mackenzie has attended:
No courses

Excel unblock

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

RE: Excel unblock

Hi there

Thanks for your post. As you have identified there are a host of issues that can cause your spreadsheet to crash.

We would really need to have a sample of your spreadsheet to evaluate along with a brief description of the main issues you are facing.

If we are confident that we can find a solution this will fall under a consultancy service and we will be able to confirm scope of work, duration and costs.

If you wish to proceed with this route, please advise.

Regards

Jacob

Wed 31 Dec 2008: Automatically marked as resolved.

 

Training courses

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Create a unique items table from a duplicating table

1. Ensure that your list has column headings
2. Select the entire list
3. From the menu bar, select DATA, FILTER, ADVANCED FILTER
4. Select "Filter the list, in place", and tick the "Unique Records Only" box
5. Click OK, filtered list appears.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.