disabling Upadte Links message

G

Gaston AGON

Hi

1) Houw cann I disable the message "Update Links..." from being displayed when opening an Excel-document

2) How can I access (in an Excel-document) the key [Start Prompt...] under the menu path
[Edition] --> [Links] --> [Start Prompt...] WHEN THE KEY [Links] IS NOT ACTIVABLE (greyed) ?

Thanks for your suggestions
 
F

Frank Kabel

Hi
try to uncheck 'Update remote references' under 'Tools - Options -
Calculation'


--
Regards
Frank Kabel
Frankfurt, Germany

Gaston AGON said:
Hi !

1) Houw cann I disable the message "Update Links..." from being
Click to expand...
displayed when opening an Excel-document ?
2) How can I access (in an Excel-document) the key [Start Prompt...] under the menu path
[Edition] --> [Links] --> [Start Prompt...] WHEN THE KEY [Links] IS NOT ACTIVABLE (greyed) ?

Thanks for your suggestions.
Click to expand...
 
G

Gaston AGON

Hin Frank

Thanks for your quick reply to my post
I've unchecked the 'Update remote references' box under 'Tools --> Options --> Calculation
and saved the document
But the message continues appearing and the checkbox is CHECKED AGAIN when I reload the document
Do you have an other idea

Thanks
Gasto
Lome (Togo
 
D

David

=?Utf-8?B?R2FzdG9uIEFHT04=?= wrote
Do you have an other idea ?
Click to expand...

Tools | Options | Edit tab:

Uncheck 'Ask to update ...'

This is global, affecting all workbooks.
 
D

Dave Peterson

There's an option that affects all workbooks you open under:
tools|Options|Edit tab|Ask to update automatic links

If you uncheck this, then every workbook you open that has external links will
be updated without the prompt.

This is a user-by-user setting. You can't change it for someone else (well,
unless you go to their pc and make the change!).

xl2002 added another links option under:
Edit|Links|Startup Prompt Button

In earlier versions, you could use a helper workbook that opens the workbook
with the links. That code in that helper workbook could specify how to open the
workbook with links.

Kind of like:

Option Explicit
Sub auto_open()
Workbooks.Open Filename:="c:\my documents\excel\book2.xls", UpdateLinks:=0
ThisWorkbook.Close savechanges:=False
End Sub

(see VBA's help for all the options for updatelinks.)

But the problem is that the linking question comes before any VBA code (in the
workbook with links) is executed.)

That's why the helper workbook is useful.

Gaston said:
Hi !

1) Houw cann I disable the message "Update Links..." from being displayed when opening an Excel-document ?

2) How can I access (in an Excel-document) the key [Start Prompt...] under the menu path
[Edition] --> [Links] --> [Start Prompt...] WHEN THE KEY [Links] IS NOT ACTIVABLE (greyed) ?

Thanks for your suggestions.
Click to expand...
 
G

Gaston AGON

Hi Dav

Thanks for your suggestions.
The "Workbooks.Open ... UpdateLinks:=0" instruction has worked fine
I was also needing your idea with the "helper-Workbook" which open
the main workbook containing the links beacause I'm using excel2000 and don't have th
"Edit|Links|Starup Prompt" - button.
I just had to suppress the instruction "This Workbook.Close..." from my code that I run in the
Workbook_Open() event procedure of my helper-workbook because that instruction skiped the
remaining code I normally run in the procedure containing the Open instruction of the helper-workbook
and leads to errors in my application
 
Top