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

In 2003 it is possible through the file properties window

File - Properties - Custom

"J Austin" wrote:

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,
Unfortunately, Excel 2007 does not have that option. Thanks for the
suggestion.
John

"Joel" wrote:

In 2003 it is possible through the file properties window

File - Properties - Custom

"J Austin" wrote:

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