| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linked spreadsheets failing to recognised that the linked file is | Excel Discussion (Misc queries) | |||
| Linked Spreadsheets | New Users to Excel | |||
| Linked spreadsheets | Excel Discussion (Misc queries) | |||
| Connecting Linked Spreadsheets | Excel Discussion (Misc queries) | |||
| linked spreadsheets | New Users to Excel | |||
Linear Mode
