up vote 3 down vote favorite
share [g+] share [fb]

I have an MS-Excel Workbook that links to another for data. The links update when the book is opened, but I still get this message "This workbook contains one or more links that cannot be updated." You get Continue or Edit Links options. I want to disable this message or prevent it from appearing, how do I do that? Thanks.

link|improve this question
Are you referring to a spreadsheet, or some other application? Which application are you using? – Randolf Richardson Jun 3 '11 at 0:40
2  
Sorry, I thought I mentioned Excel spreadsheets somewhere. – ozadam Jun 3 '11 at 8:43
I updated your question accordingly, including the tags. The "microsoft-excel" tag should bring a little bit more attention to your question from those who are more likely to know of some solutions. Welcome to SuperUser.com! – Randolf Richardson Jun 3 '11 at 8:49
2  
Thanks Randolf. – ozadam Jun 3 '11 at 8:58
feedback

1 Answer

up vote 2 down vote accepted

From MSDN -

  1. On Edit menu, click Links. Note In Excel 2007, click Edit Links in the Connections group on the Data tab.

  2. Click Startup Prompt.

  3. Click the Don't display the alert and don't update automatic links option.

Here is the link for more info - http://support.microsoft.com/kb/826921

link|improve this answer
Thankyou Ben. In combination with your tip and some playing round with a Workbook_open event so the data updates, it works. Thanks – ozadam Jun 4 '11 at 9:15
1  
you ought to accept this answer then – datatoo Jun 4 '11 at 16:45
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.