Removing links

Andy D 2002 · May 1st, 2002, 08:20 AM

Hi
Normally i run macros with "application.displayalerts=false"
I can't use this on a particular workbook and am now finding it is linked to other workbooks - i get message "workbook you opened contains automatic links to information"...and then get prompted to update etc..
how can i find and remove these links so i don't get this message anymore..?
thanks
Andy

Iain Lewis · May 1st, 2002, 08:46 AM

I have an add-in which finds & removes links. Email me if you'd like a copy ( either as a zipor as a .xla ).

The Add in is courtesy of Bill Manville ***.

May 1st, 2002, 08:20 AM	#1
Andy D 2002 Board Regular Join Date: Apr 2002 Location: Andy Devine Posts: 106	Hi Normally i run macros with "application.displayalerts=false" I can't use this on a particular workbook and am now finding it is linked to other workbooks - i get message "workbook you opened contains automatic links to information"...and then get prompted to update etc.. how can i find and remove these links so i don't get this message anymore..? thanks Andy __________________ Andy Devine

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 1st, 2002, 08:46 AM	#2
Iain Lewis Board Regular Join Date: Apr 2002 Location: Midlands, UK Posts: 217	I have an add-in which finds & removes links. Email me if you'd like a copy ( either as a zipor as a .xla ). The Add in is courtesy of Bill Manville ***.