Removing a Link

[J Austin]

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

 

[Joel]

In 2003 it is possible through the file properties window

File - Properties - Custom

 

[J Austin]

Joel,
Unfortunately, Excel 2007 does not have that option. Thanks for the
suggestion.
John