Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Microsoft Excel 2003 and Hyperion Retrieve with Excel 2000. | Excel Discussion (Misc queries) | |||
Excel XP 2002 Vs. Excel 2000 | Excel Discussion (Misc queries) | |||
other systems detecting excel 4.0 if excel 2000 is installed | Setting up and Configuration of Excel | |||
How do I Break links Using Excel 2000 | Excel Discussion (Misc queries) | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |