PDA

View Full Version : sever all ties & links



lior03
10-18-2007, 03:44 AM
hello
i am using excel 2000 .hoew can i empty through a vba code the table on the edit menu-links.
my workbook is connected to another wb and on opening the workbook i get a msgbox.could it be disabled?
thanks

Bob Phillips
10-18-2007, 03:58 AM
Workbooks.Open Filename:="filename.xls", Updatelinks:=0