Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
Phantom Worksheet Link Puzzle
I have created a new spreadsheet in Excel 2000 which involved some copying
and pasting from a previous spreadsheet. There are multiple worksheets in the xls. Its fairly complex so don't want to recreate the whole thing again. At one point the copy of a worksheet failed (crash with error report request). The new spreadsheet seems to be OK, except on opening it is asking for the password for a link to another spreadsheet. There is no link to that spreadsheet anywhere in the new spreadsheet. I've searched the entire spreadsheet and there is no genuine link. So I used the Findlink add-in and it found a link to the spreadsheet. But it names the source of the link as a worksheet which doesn't exist - the source worksheet has a name something like G!11Ps. There is no worksheet of that name in the new spreadsheet. When Findlink is asked to remove the link it gives an error and doesn't remove it. It seems there is a phantom worksheet in the new spreadsheet -- and the phantom has the link that is coming up on open. How can I find and get rid of the phantom worksheet ? Any ideas? -- regards ....barglen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I link a worksheet to another worksheet? | Excel Discussion (Misc queries) | |||
How can I link from an external website to a particular worksheet | Excel Worksheet Functions | |||
How do I copy a worksheet without the link to the original workboo | Excel Discussion (Misc queries) | |||
How do link to a remote worksheet using the path value in a field? | Links and Linking in Excel | |||
Copy worksheet with Pivot Table and break link to original workshe | Excel Worksheet Functions |