Suppressing "This workbook contains links to other data sources."prompt

P

PeteCresswell

I figured that setting Tools | Options | Calculation | Update remote
references = False would do the trick, but no luck.

When I open the sheet again, the prompt persists and Update remobe
references has been magically reset to True.

Is there another option/parm? Or is that just the way it is?
 
B

BruceM

This sounds like an Excel question, in which case it would be best to ask it
in an Excel group. This group is for discussions about Microsoft Access, a
relational database program.
 
S

strive4peace

Hi Pete,

this is an Excel question and should be posted in an Excel forum ... but
here is information from

http://support.microsoft.com/kb/110006

'~~~~~~~~~~~~
Sub Example()
' The zero after updateLinks indicates that neither external nor
' remote references should be updated when the file is opened.
Workbooks.Open fileName:="C:\EXCEL\TEST.XLS", updateLinks:=0
' Turn off the Update Remote References setting for the workbook.
ActiveWorkbook.UpdateRemoteReferences = False
End Sub
'~~~~~~~~~~~~

"Note The Update Remote References check box is not a universal setting.
When two workbooks are open, one workbook might have its Update Remote
References setting selected whereas the check box is cleared in the
other workbook. However, when you open a workbook, its Update Remote
References check box will be selected, no matter how it was saved,
unless it contains links to an external data source."


Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
:) have an awesome day :)
*
 
Top