Removing Links J Austin 10/3/2008 8:16:03 PM I have a link in a Excel 2007 spreadsheet that I believe is giving me a Not a Valid Reference error when I do a refresh to an linked Access table. If I go to edit links and break the link it doesn't seem to do anything. It says status is unkown and if I try and open the source, it says it cannot find it. Is this information stored someplace that it can be edited directly? Or any other way to remove it? Thanks, J Austin

Re: Removing Links "Rainald Taesler" <taesler[ at ]gmx.de> 10/4/2008 10:39:53 PM J Austin wrote: [Quoted Text] > I have a link in a Excel 2007 spreadsheet that I believe is giving > me a Not a Valid Reference error when I do a refresh to an linked > Access table. If I go to edit links and break the link it doesn't > seem to do anything. It says status is unkown and if I try and > open the source, it says it cannot find it. Is this information > stored someplace that it can be edited directly? Or any other way > to remove it? Just wondering: What has this to do with *OneNote*? You might ask one of the dedicated Excel groups. Rainald

Re: Removing Links "Ben M. Schorr - MVP (OneNote)" <bens[ at ]bogusaddress.mvp> 10/6/2008 9:15:29 AM I think you meant to ask this in an Excel newsgroup. This group is for OneNote. -- -Ben- Ben M. Schorr, MVP Roland Schorr & Tower http://www.rolandschorr.com http://www.officeforlawyers.com Author - The Lawyer's Guide to Microsoft Outlook 2007: http://tinyurl.com/5m3f5q "J Austin" <JAustin[ at ]discussions.microsoft.com> wrote in message news:84A4D3B5-18A4-45E4-9025-16E6818D2563[ at ]microsoft.com: [Quoted Text] > I have a link in a Excel 2007 spreadsheet that I believe is giving me a Not a > Valid Reference error when I do a refresh to an linked Access table. If I go > to edit links and break the link it doesn't seem to do anything. It says > status is unkown and if I try and open the source, it says it cannot find it. > Is this information stored someplace that it can be edited directly? Or any > other way to remove it? > > Thanks, > > J Austin