Go to the cell that has the live link. Use your arrows so you don't
click it inadvertently. Resize the column. See if the problem goes
away. If not, try arrowing over to the cell that has the incorrect
format, and go Edit->Clear->Formats.
HTH.
Geoff
> Boy, excel issues never end.
>
[quoted text clipped - 10 lines]
> OS 10.4.7
> Office 2004
On 12/20/06 8:33 PM, in article
1166675581.316807.6330@t46g2000cwa.googlegroups.com, "Geoff Lilley"
<ruthlesslightning@gmail.com> wrote:
> Go to the cell that has the live link. Use your arrows so you don't
> click it inadvertently. Resize the column. See if the problem goes
[quoted text clipped - 19 lines]
>> OS 10.4.7
>> Office 2004
Geoff:thanks, that did it clear formats. But why does this happen?? I've
gotten it a few time. It's like then the formatting is bleeding over to the
next cell???
OS 10.4.7
Office 2004
Geoff Lilley - 29 Dec 2006 08:50 GMT
Sorry for the delay in response. Help me understand - even if you
re-size the column, the hyperlink is still carrying over to the next
column? Is that happening on a new sheet with no other data on it, or
is it just a single worksheet where that issue occurs? Let me know.
Geoff
> On 12/20/06 8:33 PM, in article
> 1166675581.316807.6330@t46g2000cwa.googlegroups.com, "Geoff Lilley"
[quoted text clipped - 30 lines]
> OS 10.4.7
> Office 2004
Geoff Lilley - 29 Dec 2006 08:51 GMT
PS- I saw that you have a few posts in here where formatting is giving
you a hard time. You might want to go to your "Tools" menu, then go to
"Customize Menus/Toolbars" and put a "Clear Formatting" button on your
Standard toolbar. Alternatively, make a keyboard shortcut that does it
(Tools->Customize->Keyboard). That might be useful.
Geoff
> On 12/20/06 8:33 PM, in article
> 1166675581.316807.6330@t46g2000cwa.googlegroups.com, "Geoff Lilley"
[quoted text clipped - 30 lines]
> OS 10.4.7
> Office 2004