Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
deleting Excel links
Name: halenhardy Date: December 10, 2003 at 00:17:08 Pacific OS: win ME CPU/Ram: pent/128
Comment:
I have an Excel file that when I open it, it says I have a link to another file. Checking the link option in Edit, it shows me what file I am linked to but I can't find any way to delete the link. I also have no idea what the link is or why there is a link. Any ideas..Thanks Gary
Name: Bryco Date: December 10, 2003 at 03:49:58 Pacific
Reply:
Ctrl+`(~) will toggle 'Show formulas'
You can then see where and what links are used.
Toggle again to stop showing the formulas.
If the links are all in one column then right click on the column letter, select Copy, right click on it again and select Paste Special, Values.
If you are not concerned about the calucatlions or other formulas then do the same for the entire sheet instead.
Save when done.
HTH Bryan
0
Response Number 2
Name: halenhardy Date: December 10, 2003 at 16:07:02 Pacific
Reply:
Bryan.. Pressing Control` just doubles the width of the worksheet columns. Doing it again puts the columns back. I have Office 2000. The manual I have is Excel 5.0 and it says that Ctrl+` does what you say. Is there something else I can try. Thanks.. Gary
0
Response Number 3
Name: Bryco Date: December 11, 2003 at 04:27:47 Pacific
Reply:
Gary,
It does this to accomodate the width so you can view the formulas. It will do that on sheets that have no formulas too. Have a look around the cells for your formulas.
Bryan
0
Response Number 4
Name: halenhardy Date: December 11, 2003 at 14:31:38 Pacific
Reply:
Bryan.. I looked through every sheet in the workbook but found no links. I finally created a new workbook and copied the worksheets from the old to the new, 1 at a time and closed/opened the new workbook. Got the worksheets loaded and then copied the macro from the old to the new and now everythings ok. I know I had no links to the workbook the link option said I did. It was even in a different folder. I'm supprised there isn't a "Delete Link" option available. Thanks again. Gary
Summary: Hello, I had a heck of a time finding this and I wanted to post something in hopes that it will help someone else out: I recently had a customer with a problem where they could not open embedded Exce...
Summary: Hi there I'm having a bit of trouble with links between one Excel doc and another. They work perfectly as long as both docs are open, but if, for example document 2 (referred to by a main document, do...
Summary: My new installation of Microsoft 2003 (new computer) doesn't allow me to update links between Publisher and Excel that were setup under my old computer. When I do try to update an excel table or graph...
0 
