Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

update links = NO

  Asked By: Carole    Date: Jan 10    Category: MS Office    Views: 581
  

I have code that opens an excel sheet that always tells me the file
has links and do I want to update the file. The answer will always
be "No" for my application.

I already disabled the alerts but I still get the questions:

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

I have coded:

Application.DisplayAlerts = False
Application.Workbooks.Open (CurrentDirectory & "\" & FileName)

What am I missing?

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Julia Hughes     Answered On: Jan 10

UpdateLinks:=False

It's the next parameter in the Open call after the file  name.

If you've missed that, it sounds as though you might have "auto quick info"
turned off. Check your options in the VBE. Ideally you'll have all the
checkboxes in the "Editor" pane ticked.

 
Didn't find what you were looking for? Find more on update links = NO Or get search suggestion and latest updates.




Tagged: