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