Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 17th 05, 12:29 PM
Nevio
 
Posts: n/a
Default Breaking Links in Excel 2000

How do I break a Link in Excel 2000; I can see how to do it in Excel 2003,
but I am using 2000; can anyone help.

  #2   Report Post  
Old August 17th 05, 12:53 PM
Mark Hone
 
Posts: n/a
Default

Hi Nevio,

Try the following:
- Ctrl F to find - look for .xls and .csv and manually amend any formulae
that contain references to other sources. Also search for any other file
extensions of files to which you may be linked. If you have a bunch of
linked cells together, select them all, copy and paste as values to remove
the links.

- If you have range names set up, select Insert, Name, Define from the menu
and amend or delete any names that relate to other workbooks.

- If you have charts (and still have links), you will need to check the data
source for each one to see if the chart references another workbook.

Alternatively, if all that seems like hard work, create your own utility to
do it for you:
http://www.microsoft.com/europe/vba/...nloads/159.htm

Hope this helps,

Mark


"Nevio" wrote:

How do I break a Link in Excel 2000; I can see how to do it in Excel 2003,
but I am using 2000; can anyone help.

  #3   Report Post  
Old August 17th 05, 01:26 PM
Nevio
 
Posts: n/a
Default

Many thanks Mark, your suggetion resolved the problem.

Nevio
-------------------------------------
"Mark Hone" wrote:

Hi Nevio,

Try the following:
- Ctrl F to find - look for .xls and .csv and manually amend any formulae
that contain references to other sources. Also search for any other file
extensions of files to which you may be linked. If you have a bunch of
linked cells together, select them all, copy and paste as values to remove
the links.

- If you have range names set up, select Insert, Name, Define from the menu
and amend or delete any names that relate to other workbooks.

- If you have charts (and still have links), you will need to check the data
source for each one to see if the chart references another workbook.

Alternatively, if all that seems like hard work, create your own utility to
do it for you:
http://www.microsoft.com/europe/vba/...nloads/159.htm

Hope this helps,

Mark


"Nevio" wrote:

How do I break a Link in Excel 2000; I can see how to do it in Excel 2003,
but I am using 2000; can anyone help.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Microsoft Excel 2003 and Hyperion Retrieve with Excel 2000. Juan Angel Excel Discussion (Misc queries) 1 June 21st 05 09:55 PM
Excel XP 2002 Vs. Excel 2000 Samantha Excel Discussion (Misc queries) 0 April 18th 05 03:54 PM
other systems detecting excel 4.0 if excel 2000 is installed Tristan_Flynn Setting up and Configuration of Excel 0 January 18th 05 06:55 PM
How do I Break links Using Excel 2000 DaddyMan Excel Discussion (Misc queries) 1 December 9th 04 10:18 PM
Statistical Excel Function Question within Excel 2000... Drew H Excel Worksheet Functions 3 October 31st 04 06:55 PM


All times are GMT +1. The time now is 03:59 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017