Don't display alert and update links...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

guy - 22 Oct 2004 19:05 GMT

I have (from the links menu): "Don't display alert and update links..."
checked but it still comes up with a message box:

This workbook contains links to other data sources.
- To update all linked information, click Yes.
- To keep the existing information, click No.

Any ideas

Reply to this Message

Bill Manville - 23 Oct 2004 07:41 GMT

Guy wrote:

> I have (from the links menu): "Don't display alert and update links..."
> checked but it still comes up with a message box:
>
> This workbook contains links to other data sources.
> - To update all linked information, click Yes.
> - To keep the existing information, click No.

The Edit / Links / Startup Prompt talks specifically about links to other
workbooks. You clearly have links to other sources.

Try Tools / Options / Calculation / Update Remote References - off

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Reply to this Message

guy - 07 Nov 2004 20:17 GMT

Bill - hope you don't mind I've also (assuming that Mary sent you her
spreadsheet) sent you the one I've been having problems with.

Thanks

> Guy wrote:
>> I have (from the links menu): "Don't display alert and update links..."
[quoted text clipped - 12 lines]
> MVP - Microsoft Excel, Oxford, England
> No email replies please - respond to newsgroup

Reply to this Message

Bill Manville - 08 Nov 2004 01:12 GMT

Guy wrote:

> hope you don't mind I've also (assuming that Mary sent you her
> spreadsheet) sent you the one I've been having problems with.

The easy way to get rid of the message is
Edit / Links / Startup Prompt / Don't display the message and DON'T
update links.

..and I think my advice to switch off
Tools / Options / Calculation / Update remote references
was wrong in that case.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Reply to this Message

guy - 08 Nov 2004 17:16 GMT

Problem is that the links aren't updated...?

This is a spreadsheet with a live feed that needs to be updated...

Reply to this Message

Bill Manville - 09 Nov 2004 07:36 GMT

Guy wrote:

> This is a spreadsheet with a live feed that needs to be updated...

If I am not mistaken they will update after the workbook has been
opened; we were merely trying to prevent the update message appearing
when the book was opened.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Reply to this Message

Mary - 09 Nov 2004 16:06 GMT

Try using "Let user decide whether to display the alert or not." When I used
this setting, the alerts stopped appearing when I opened the workbook, but
the data did get updated as I wanted.

Mary

> Problem is that the links aren't updated...?
>
> This is a spreadsheet with a live feed that needs to be updated...

Reply to this Message