Re: "Error! Not a valid link."

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Beth Melton (bmelton_at_NoSpam4Memvps.org)
Date: 11/23/04 

Date: Mon, 22 Nov 2004 19:11:07 -0600

You are correct, it is an unlikely fluke. :-) It was an odd bug with
a strange pattern of behavior. I spent some time with it after another
poster reported it in the newsgroups so I could enter it in the bug
database. I found typically cell A1 would always work and if you
didn't encounter the error in one cell you wouldn't encounter it in an
adjacent cell. For example in a in a three column table if the paste
special worked in a cell in column B it would also work in the
adjacent cell in column C. e.g. B5, C5, B9, C9, B15, C15, B20, C20,
etc. And if you went to Edit/Links and selected "Open Source" the
Excel workbook will open and select the correct cell used in the link.

In any event, if you find the formatted text doesn't work for you then
another poster reported changing the text alignment to either Center
or Right resolved it for them. I can't verify this since I'm unable to
reproduce it now. Otherwise install the SP-3 patch to correct it. 

-- 
Please post all follow-up questions to the newsgroup. Requests for 
assistance by email can not be acknowledged.
~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/
"Kamran" <Kamran@discussions.microsoft.com> wrote in message 
news:AC083B96-A850-4DF9-863F-47660D302DAF@microsoft.com...
> I've got Office 2002 SP2.  That's one of those flukes you would be 
> very
> unlikely to find.
>
> "Beth Melton" wrote:
>
>> IIRC this bug was corrected in the Office 2002 SP3. What version of
>> Word are you using and what patches do you have installed?

Relevant Pages

  • Re: simpler example of the padding bug
    ... It's not a bug. ... |> width of the contained content, plus the padding, plus the border, plus ... The margin, border and padding ... 100% inside a table cell, the outer edge of the content would be the same ...
    (comp.infosystems.www.authoring.stylesheets)
  • Re: Range.Find returns cell outside of range when range set to single cell
    ... Thanks for the reply, for confirming the bug, and for recording the issue as ... If the find hit is on the extended cell than that hit ... > Microsoft Developer Support ...
    (microsoft.public.excel.programming)
  • Re: Populate lists automatically
    ... This is not a bug. ... as you go to select Weekday or Month in any cell in the range ... Select category as Fruits, Select Apple from Item. ... I have a requirement which has 2 lists to be populated ...
    (microsoft.public.excel.misc)
  • Re: simpler example of the padding bug
    ... as the inner edge of the table cell. ... the red box should line up with the border of the blue box way. ... I think it may be a bug in Mozilla's rendering code. ... who deal with Firefox bugs, and they've all agreed it is a bug. ...
    (comp.infosystems.www.authoring.stylesheets)