I can view links, but can't delete them Alifrog 21.12.2005 18:41:24 I have an Excel spreadsheet with links to several Excel spreadsheets that have been deleted. I can view the links by clicking on Edit and Links, but there is no option to delete them, only update now, open source, and change source. Any ideas on how I can delete all my links?

RE: I can view links, but can't delete them Alifrog 23.12.2005 21:42:02 Nevermind. With more searching, I found out how to do this. I just don't know how to delete this thread. "Alifrog" wrote: [Quoted Text] > I have an Excel spreadsheet with links to several Excel spreadsheets that > have been deleted. I can view the links by clicking on Edit and Links, but > there is no option to delete them, only update now, open source, and change > source. Any ideas on how I can delete all my links?

Re: I can view links, but can't delete them "Ken Wright" <ken.wright[ at ]NOSPAMntlworld.com> 30.01.2006 23:46:18 You can't, so I wouldn't worry about it. You have at least taken the time to post that the question is closed which is more than many would bother to do :-) -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------­------------------------------­---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------­------------------------------­---------------- "Alifrog" <Alifrog[ at ]discussions.microsoft.com> wrote in message news:57317D76-F861-4D3B-95D4-15607F2AD6CF[ at ]microsoft.com... [Quoted Text] > Nevermind. With more searching, I found out how to do this. I just don't > know how to delete this thread. > > "Alifrog" wrote: > >> I have an Excel spreadsheet with links to several Excel spreadsheets that >> have been deleted. I can view the links by clicking on Edit and Links, >> but >> there is no option to delete them, only update now, open source, and >> change >> source. Any ideas on how I can delete all my links?

Re: I can view links, but can't delete them stickboy <stickboy.23clfj[ at ]news.excelbanter.com> 16.02.2006 22:26:11 My problem is that I want to change the source workbook but the Change source button is not available? The source file updates weekly (one for Monday, tuesday, etc). Before these files are updated, they are archived to a different folder but all under the same name (i.e. MON TUE WED etc.). I want my formulas to compute using the archived files but the Change Source button is not available! I had to change the formula references in each of the 30 workbooks containing 9 wokrsheet each!!! HEEELLPPP!!! Alifrog Wrote: > I have an Excel spreadsheet with links to several Excel spreadsheets > that [Quoted Text] > have been deleted. I can view the links by clicking on Edit and Links, > but > there is no option to delete them, only update now, open source, and > change > source. Any ideas on how I can delete all my links? -- stickboy

Re: I can view links, but can't delete them stickboy <stickboy.23clfk[ at ]news.excelbanter.com> 16.02.2006 22:28:46 oh... and even the UPDATe NOW button is also grayed over.... i've tried playing around with the setting in the Calculations tab of the Options menu but I can't seem to get it... should the settings be changed to manual?... which buttons should be checked/unchecked? stickboy Wrote: > My problem is that I want to change the source workbook but the Change > source button is not available? The source file updates weekly (one for > Monday, tuesday, etc). Before these files are updated, they are archived > to a different folder but all under the same name (i.e. MON TUE WED > etc.). I want my formulas to compute using the archived files but the > Change Source button is not available! I had to change the formula > references in each of the 30 workbooks containing 9 wokrsheet each!!! > HEEELLPPP!!! -- stickboy