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

popup messages

ResolvedVersion 2003

Joy has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Pop-up messages

Is there a way of getting rid of the pop up message that asks if you want to update the worksheet?

RE: Pop-up messages

Hi Joy

Thank you for your question, and apologies for the delay in replying - we currently have a high volume of posts, hence the lenghtened response time.

You can change settings in Excel on your computer to avoid seeing the update links message that appears in Excel.

Here's how:

1. Go to Tools menu and select Options, and click the Edit tab.

2. Uncheck the 'Ask to update automatic links' check box.

Links will be automatically updated on the opening of any Excle file, without the message appearing, when it is opened on the computer you have changed these settings on.

If you require further information please see http://support.microsoft.com/kb/826921

Amanda

Excel tip:

Shortcut for accessing recently opened files

To get into recently opened Excel files without using your mouse, hold down Alt + F to open the File menu.

Recently opened files are listed down the bottom of the File menu - type in the number next to the file you wish to open and it should appear on your screen.

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.12 secs.