VBA Open produces Update Links, Excel UI does not

WaltzAir

New Member
Joined
Sep 19, 2012
Messages
33
Excel 2007 VBA -- When I open a particular file from the Excel user interface or Win Explorer, the file opens without the "... links cannot be updated" dialog. When I use a empty new file and a vba code of only "Workbooks.Open filename", it opens with the dialog.
I have purged the file of all the links I can find (all defined names, formulas, validations, conditional formats).
Anybody have a theory about why this occurs or a method of attack I can take to ferret it out?
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
Found a missed cell with data validation using the Compatability Checker. However, that still leaves the question of why I did not get the dialog from the user interface -- but that is just academic now.
 
Upvote 0

Forum statistics

Threads
1,214,942
Messages
6,122,367
Members
449,080
Latest member
Armadillos

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top