Can't find link

G

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
 
D

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
 
D

Dave Peterson

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

Dave said:
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
 
G

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
Dave Peterson said:
Ps. In my simple test, I couldn't close the workbook that served as a reference
for another open workbook.

Dave said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top