W
WilliamH
Bug found in Microsoft Excel 2003
1. create basic information to sort in column A.
2. create a hyperlink in column B, skip a few spaces down and create
different hyperlink.
3. use fill defaults to create additional hyperlinks.
4. sort information based on column A.
-The text will sort correctly, but the hyperlinks that were created by "fill
defaults" do not follow the text associated with them.
-copying and pasting all info from one workbook/worksheet prior to sorting
does not resolve the problem.
-copying and pasting the hyperlinks individually works
-manually attaching a hyperlink to each cell works.
I found this bug when I was putting together a report at work.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...4548510&dg=microsoft.public.excel.crashesgpfs
1. create basic information to sort in column A.
2. create a hyperlink in column B, skip a few spaces down and create
different hyperlink.
3. use fill defaults to create additional hyperlinks.
4. sort information based on column A.
-The text will sort correctly, but the hyperlinks that were created by "fill
defaults" do not follow the text associated with them.
-copying and pasting all info from one workbook/worksheet prior to sorting
does not resolve the problem.
-copying and pasting the hyperlinks individually works
-manually attaching a hyperlink to each cell works.
I found this bug when I was putting together a report at work.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...4548510&dg=microsoft.public.excel.crashesgpfs