View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.links
barglen barglen is offline
external usenet poster
 
Posts: 6
Default Phantom Worksheet Link Puzzle

Thanks Macropod,
I didn't know about that feature - yes I can see the weird name in "defined
names". And it refrers to the spreadsheet thta is being asked for on open.
But when I try to delete the defined name I get the message - "that name is
not valid".
I tried modifying it by blanking out the reference but still get "name not
valid" when I try to save it.
Any further advice? Appreciate the help so far.
regards
....barglen


"macropod" wrote:

Hi barglen,

If the name isn't in any worksheet cells, it could nevertheless be in a
defined named. Check in Insert|Name for the offending reference in the defined
names.

Cheers

--
macropod
[MVP - Microsoft Word]


"barglen" wrote in message
...
| 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