Update Links

V

V. Roe

I have been using the line of code below to open a file without the update
links prompt. It suddenly has begun showing the prompt. The only change I
can see is that someone has opened and saved the workbook I am trying to
open without updating links in excel 2000, and I am using 97. Can anyone
tell me why this would suddenly start showing the prompt asking to update
links? I have been using this code for months without changes. Thanks
Valerie

Workbooks.Open FileName:="T:\Voc Rehab\Voc Master Files\Revised Voc
Form.xlt", UpdateLinks:=False
 
V

V. Roe

Sorry for the trouble, I answered my own question after I posted. Problem
was with the previous line of code not the one posted.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sub projects added as read only in Master file which are saved on sharepoint 1
XL03: Avoid "workbook contains links" msg when opening 6
UpdateLinks Popup on Workbooks.Open 0
UpdateLinks Popup on Workbooks.Open 0
embedding pw's to master sheet & auto update w/out pw's 0
Word 2016 opening sooo slow 0
Link error/Warning using macro in files converted to Excel 2007 (. 0
Reference issues in Excel 2003 2

Top