Excel XP cells are links

[Guest]

All of a sudden every Excel XP cell shows up as a link

 

[Anne Troy]

A link to what?
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[Guest]

Hi Anne, it links just to another excel file, but only on certain pages and
then
always to the same file. It's disgusting..

 

[Anne Troy]

So you saved the file to a new name? Have you tried Edit-->Links? Or try
these:
http://www.officearticles.com/excel/removing_links_in_microsoft_excel.htm

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[Guest]

I tried all kinds of things. so far the only thing which seems to work is
deleting the page and start a new on..

 

[Dave Peterson]

What do you type into the cell?

What do the links show?

Could it be that the cells have a style of Hyperlink so that they look like
links?

select a problem cell (for testing)
format|Style
Does Style Name show Hyperlink?
if yes, change it to normal.
If no, then never mind.

You can use ctrl-a (twice in xl2003) to select all the cells and change the
style all at once if you want.

 

[Guest]

Thanks, Dave.

it is an empty cell and as soon as I go over with the mouse it shows a link
to another worksheet. Thew style of the cell is normal. With "right-clicking"
and "remove hyperlink" it is ok, but I have to do it with each cell and how
many cells has a whole worksheet .. :-/

 

[Dave Peterson]

It sounds like all the cells have existing links there.

Select all the cells (ctrl-A (twice in xl2003))
hit alt-f11 (to get to the VBE, where macros live)
hit ctrl-g (to see the immediate window)

type this and hit enter:

selection.hyperlinks.delete

Close the VBE and back to excel to see if it worked.

===
You could even just select a smaller range and just clean that since the command
uses the current selection.