Can't find link

[Guest]

Moved an Excel file from one PC to another. New PC won't close file without
the "referenced by another workbook" message. I click OK and close file and
it seems to save data correctly.

The Edit->Links menu item isn't enabled. I've downloaded and used the
findlink.zip file from MVP page -- no help. I've tried Edit->Find using "["
-- no help.

Any idea how I can find/delete invalid link?

Thanks for any help................. and Happy New Year!

Kim

 

[Dave Peterson]

You could have another workbook that has a reference to this workbook in its
project.

Open your workbook (the same way that causes the warning message).
Go into the VBE (alt-f11 is one way)
hit ctrl-r (to see the project explorer)

You should see a layout like windows explorer.

Note the name of your workbook and it's project's name. (It could be
VBAProject, but it's probably been renamed).

Note the workbooks that are open.
click on each one of those workbooks (to select it)
then click on Tools|References
look for a reference to your workbook in that list.

Uncheck it or determine if it's required.

If you unchecked that reference, save that workbook so that the reference is
deleted.

Now try closing your workbook(s).

Moved an Excel file from one PC to another. New PC won't close file without
the "referenced by another workbook" message. I click OK and close file and
it seems to save data correctly.

The Edit->Links menu item isn't enabled. I've downloaded and used the
findlink.zip file from MVP page -- no help. I've tried Edit->Find using "["
-- no help.

Any idea how I can find/delete invalid link?

Thanks for any help................. and Happy New Year!

Kim

 

[Dave Peterson]

Ps. In my simple test, I couldn't close the workbook that served as a reference
for another open workbook.

You could have another workbook that has a reference to this workbook in its
project.

Open your workbook (the same way that causes the warning message).
Go into the VBE (alt-f11 is one way)
hit ctrl-r (to see the project explorer)

You should see a layout like windows explorer.

Note the name of your workbook and it's project's name. (It could be
VBAProject, but it's probably been renamed).

Note the workbooks that are open.
click on each one of those workbooks (to select it)
then click on Tools|References
look for a reference to your workbook in that list.

Uncheck it or determine if it's required.

If you unchecked that reference, save that workbook so that the reference is
deleted.

Now try closing your workbook(s).

Moved an Excel file from one PC to another. New PC won't close file without
the "referenced by another workbook" message. I click OK and close file and
it seems to save data correctly.

The Edit->Links menu item isn't enabled. I've downloaded and used the
findlink.zip file from MVP page -- no help. I've tried Edit->Find using "["
-- no help.

Any idea how I can find/delete invalid link?

Thanks for any help................. and Happy New Year!

Kim

 

[Guest]

Dave,

Thanks for the help. I'll work at it. All project folders (Objects w/20
sheets, Modules & References) have the same 13 references. Nothing jumps out
at me but it'll take a moment to sort through each reference to answer the
"need" (or not)question.

Thanks again.

Kim

Ps. In my simple test, I couldn't close the workbook that served as a reference
for another open workbook.

You could have another workbook that has a reference to this workbook in its
project.

Open your workbook (the same way that causes the warning message).
Go into the VBE (alt-f11 is one way)
hit ctrl-r (to see the project explorer)

You should see a layout like windows explorer.

Note the name of your workbook and it's project's name. (It could be
VBAProject, but it's probably been renamed).

Note the workbooks that are open.
click on each one of those workbooks (to select it)
then click on Tools|References
look for a reference to your workbook in that list.

Uncheck it or determine if it's required.

If you unchecked that reference, save that workbook so that the reference is
deleted.

Now try closing your workbook(s).

Moved an Excel file from one PC to another. New PC won't close file without
the "referenced by another workbook" message. I click OK and close file and
it seems to save data correctly.

The Edit->Links menu item isn't enabled. I've downloaded and used the
findlink.zip file from MVP page -- no help. I've tried Edit->Find using "["
-- no help.

Any idea how I can find/delete invalid link?

Thanks for any help................. and Happy New Year!

Kim