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.

Wolf Zscheile wrote:

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" wrote:

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.



Wolf Zscheile wrote:

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

"Anne Troy" wrote:

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

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

www.OfficeArticles.com
www.MyExpertsOnline.com


"Wolf Zscheile" wrote in message
...
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" wrote:

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

www.OfficeArticles.com
www.MyExpertsOnline.com


"Wolf Zscheile" <Wolf wrote in
message
...
All of a sudden every Excel XP cell shows up as a link







--

Dave Peterson


--

Dave Peterson