Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't find link
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't find link
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). Kim wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't find link
Ps. In my simple test, I couldn't close the workbook that served as a reference
for another open workbook. Dave Peterson wrote: 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). Kim wrote: 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 -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't find link
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" wrote: Ps. In my simple test, I couldn't close the workbook that served as a reference for another open workbook. Dave Peterson wrote: 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). Kim wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dropdown list to a page in worksheet | New Users to Excel | |||
Find & Replace a link to another worksheet in the same workbook | Excel Worksheet Functions | |||
removing automatic link | Excel Discussion (Misc queries) | |||
find & replace link | Excel Worksheet Functions | |||
Breaking the link | New Users to Excel |