Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel XP cells are links
All of a sudden every Excel XP cell shows up as a link
|
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
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 |
#8
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to link website data to Excel cells | Excel Discussion (Misc queries) | |||
Filling cells (autofil?) in Excel 2003 | Excel Discussion (Misc queries) | |||
Want Excel to break links between worksheets in same file | Excel Worksheet Functions | |||
Calculating Cells causes Excel to stop responding | Excel Discussion (Misc queries) | |||
How can I have excel search and add multiple cells to find a targe | Excel Discussion (Misc queries) |