W
Wolf Zscheile
All of a sudden every Excel XP cell shows up as a link
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Anne Troy
W
Wolf Zscheile
Hi Anne, it links just to another excel file, but only on certain pages and
then
always to the same file. It's disgusting..
then
always to the same file. It's disgusting..
A
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
these:
http://www.officearticles.com/excel/removing_links_in_microsoft_excel.htm
*******************
~Anne Troy
www.OfficeArticles.com
www.MyExpertsOnline.com
W
Wolf Zscheile
I tried all kinds of things. so far the only thing which seems to work is
deleting the page and start a new on..
deleting the page and start a new on..
D
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.
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.
W
Wolf Zscheile
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 .. :-/
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 .. :-/
D
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.
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.