Linked spreadsheets
 

When opening a spreadsheet which is linked to another, the "This workbook
contains links to other data sources" information message appears. You can
then either choose to 'update' or 'don't update'.
Is it possible to disable this message and have the update happen
automatically?
Also, as this update takes approx. 10 - 15 seconds here, could there be an
"Updating information" message appear (while updating) in a specified cell or
is that being a bit adventurous?
--
tia

Jock

Linked spreadsheets
 

Try this

workbooks.Open(Filename, UpdateLinks:= True)

Replace Filename with your filename (including the path)

HTH,
Barb Reinhardt

"Jock" wrote:

When opening a spreadsheet which is linked to another, the "This workbook
contains links to other data sources" information message appears. You can
then either choose to 'update' or 'don't update'.
Is it possible to disable this message and have the update happen
automatically?
Also, as this update takes approx. 10 - 15 seconds here, could there be an
"Updating information" message appear (while updating) in a specified cell or
is that being a bit adventurous?
--
tia

Jock

Linked spreadsheets
 

tools=options=Edit tab, uncheck Ask to Update Automatic Links.

--
Regards,
Tom Ogilvy



"Jock" wrote:

When opening a spreadsheet which is linked to another, the "This workbook
contains links to other data sources" information message appears. You can
then either choose to 'update' or 'don't update'.
Is it possible to disable this message and have the update happen
automatically?
Also, as this update takes approx. 10 - 15 seconds here, could there be an
"Updating information" message appear (while updating) in a specified cell or
is that being a bit adventurous?
--
tia

Jock

Linked spreadsheets
 

Thanks guys
--
tia

Jock


"Tom Ogilvy" wrote:

tools=options=Edit tab, uncheck Ask to Update Automatic Links.

--
Regards,
Tom Ogilvy



"Jock" wrote:

When opening a spreadsheet which is linked to another, the "This workbook
contains links to other data sources" information message appears. You can
then either choose to 'update' or 'don't update'.
Is it possible to disable this message and have the update happen
automatically?
Also, as this update takes approx. 10 - 15 seconds here, could there be an
"Updating information" message appear (while updating) in a specified cell or
is that being a bit adventurous?
--
tia

Jock