How do I eliminate an "Automatic Link" in an Excel Spreadsheet?
--
Jim

Convert whatever that link is to a value?

If you're having trouble finding that link,
get Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

Jim Murray wrote:

How do I eliminate an "Automatic Link" in an Excel Spreadsheet?
--
Jim

--

Dave Peterson

The Link is to another workbook ( .xls File ) I have already eliminated.
But, the Automatic Link still ask if I want to update everytime I open my
worksheet. How do I stop this. I thought it might be part of a macro, but I
have also eliminated all of my macros.

Thanks,
--
Jim


"Dave Peterson" wrote:

Convert whatever that link is to a value?

If you're having trouble finding that link,
get Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

Jim Murray wrote:

How do I eliminate an "Automatic Link" in an Excel Spreadsheet?
--
Jim

--

Dave Peterson

I think you missed one of the links.

Jim Murray wrote:

The Link is to another workbook ( .xls File ) I have already eliminated.
But, the Automatic Link still ask if I want to update everytime I open my
worksheet. How do I stop this. I thought it might be part of a macro, but I
have also eliminated all of my macros.

Thanks,
--
Jim

"Dave Peterson" wrote:

Convert whatever that link is to a value?

If you're having trouble finding that link,
get Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

Jim Murray wrote:

How do I eliminate an "Automatic Link" in an Excel Spreadsheet?
--
Jim

--

Dave Peterson


--

Dave Peterson

Have you checked in InsertNamesDefine to see if any names in there with
references?

Have you run Bill Manville's Findlink application?


Gord Dibben MS Excel MVP

On Sun, 26 Aug 2007 01:04:00 -0700, Jim Murray wrote:

The Link is to another workbook ( .xls File ) I have already eliminated.
But, the Automatic Link still ask if I want to update everytime I open my
worksheet. How do I stop this. I thought it might be part of a macro, but I
have also eliminated all of my macros.

Thanks,

I have Excel 2000 running on one machine and Excel 2003 running on another.
When I tried to eliminate the Link on the Excel 2003, the program presented
an avenue to rename or delete the Link, but on the Excel 2000, that option is
not available. So, I deleted the Link on the Excel 2003 and copied the
modified file to the Excel 2000 Computer. But, the Excel 2000 computer still
requested to automatic link update. So, to solve my problem, I installed
Excel 2003 on the Excel 2000 computer. Problem solved.

I would still like to solve this question...

Thanks for the help,

Jim
--
Jim


"Gord Dibben" wrote:

Have you checked in InsertNamesDefine to see if any names in there with
references?

Have you run Bill Manville's Findlink application?


Gord Dibben MS Excel MVP

On Sun, 26 Aug 2007 01:04:00 -0700, Jim Murray wrote:

The Link is to another workbook ( .xls File ) I have already eliminated.
But, the Automatic Link still ask if I want to update everytime I open my
worksheet. How do I stop this. I thought it might be part of a macro, but I
have also eliminated all of my macros.

Thanks,