| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 66582 | 2006-02-28 03:54:00 | MS Excel Link problem | dcsp (9883) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 434398 | 2006-02-28 03:54:00 | I copy, rename and re-use an Excel spread-sheet on an annual basis. However, it seems to have a link to an old, long since cancelled, file. I cannot find the (or any) cell which requires this link in order to erase it. Can anyone tell me how to find where this link originates - I know I can cancel the requirement after it comes up, but the whole process is annoying? Thanks dcsp |
dcsp (9883) | ||
| 434399 | 2006-02-28 04:04:00 | In Excel - Edit - Links You will get the option to break the link there. |
godfather (25) | ||
| 434400 | 2006-02-28 04:28:00 | There is a utility called dellinks.exe that breaks old links in Excel. You can get it from one of these pages (www.google.com). | FoxyMX (5) | ||
| 434401 | 2006-02-28 05:05:00 | But its much easier to use the edit link facility in Excel, Foxy. You also get to see what document its linked to as a bonus. |
godfather (25) | ||
| 434402 | 2006-02-28 05:10:00 | Features, features, features. That one seems to be not too well hidden, but ... ;) I believe that most of the features which people ask to be added to the MS Office are already there. It's just that there are so many features that people can't find them. :cool: |
Graham L (2) | ||
| 434403 | 2006-02-28 07:03:00 | But its much easier to use the edit link facility in Excel, Foxy. You also get to see what document its linked to as a bonus. Yes, definitely - if the link is actually visible in the worksheet. I once had a spreadsheet that, for a very long time, I wasn't able to break the link to another, deleted, spreadsheet but it kept on wanting to update itself. In the end the only way I was able to break the link and fix it was with the app referred to in my previous post. |
FoxyMX (5) | ||
| 434404 | 2006-02-28 07:14:00 | I believe that most of the features which people ask to be added to the MS Office are already there. It's just that there are so many features that people can't find them. :cool:The feature I want isn't there :) I've looked many times... many many many times... all I've ever asked is to be able to have more than 65536 rows in Excel... it seems so simple, but it's never been done :( Mike. |
Mike (15) | ||
| 434405 | 2006-02-28 07:48:00 | Yes, definitely - if the link is actually visible in the worksheet. I once had a spreadsheet that, for a very long time, I wasn't able to break the link to another, deleted, spreadsheet but it kept on wanting to update itself. In the end the only way I was able to break the link and fix it was with the app referred to in my previous post. That has to be a corruption in the spreadsheet though, as if there is no editable link then there is no actual link. |
godfather (25) | ||
| 434406 | 2006-02-28 18:11:00 | The feature I want isn't there :) I've looked many times... many many many times... all I've ever asked is to be able to have more than 65536 rows in Excel... it seems so simple, but it's never been done :( Mike. Hi Mike, I believe the 655536 row limit will be increased when MS release a 64-bit version of Excel. My understanding is the row limit will be >1,000,000. |
Parry (5696) | ||
| 434407 | 2006-02-28 18:50:00 | Hi Mike, I believe the 655536 row limit will be increased when MS release a 64-bit version of Excel. My understanding is the row limit will be >1,000,000.That would be terrific! I usually need around the 300,000 mark, so that would work just find for me ;) I suppose that would require a 64bit processor and a 64 bit OS? Hmmm... That might swing me toward a certain CPU brand for my new PC ;) Mike. |
Mike (15) | ||
| 1 2 | |||||