Excel report

I asked this question a while ago, but never received any help. If anyone
knows about this, your answer is much appreciated.
I export a report with links into Excel. When I open the Excel report and
put my mouse over the link, the URL is displayed. This is unacceptable
because the URL contains hidden data that we pass between reports.
Can this be prevented?
Thank you,
MelissaHi Melissa,
Thanks for your post.
From your descriptions, I understood that the you do not want the links to
be shown when Reports had been exported to Excel formats. Have I understood
you? Correct me if I was wrong. However, I am not sure whether you still
want this URL to be valid? (For example, it dispalyed as "Hello" and it's
internal URL was http://www.mydomain.com/hiddendata, do you still want
http://www.mydomain.com/hiddendata stored somewhere in Excel or it could be
delete, you just want it be displayed as "Hello"?)
Based on my scope, unfortuantely, this behavior is by design in Excel. As
we all known, when you type an entry in your worksheet that begins with any
of the following prefixes (http://, www., ftp://, mailto:, file://, news:,
\\), Microsoft Excel automatically creates a hyperlink. Also, I am afraid
there is no options in Reporting Services could be used to realize such
functionality.
However, I think the following KB might be help in Excel side, but you will
have to do it manually
XL2002: How to Prevent the Automatic Creation of Hyperlinks
http://support.microsoft.com/kb/291209/EN-US/
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Thanks for the answer Michael.
I am just looking to display the text in Excel without the link.
I checked the link that you mentioned, and it's a good solution, but I have
no idea how to accomplish this upon exporting the report to Excel.
Melissa
""Michael Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:T8P1r3luEHA.3388@.cpmsftngxa10.phx.gbl...
> Hi Melissa,
> Thanks for your post.
> From your descriptions, I understood that the you do not want the links to
> be shown when Reports had been exported to Excel formats. Have I
understood
> you? Correct me if I was wrong. However, I am not sure whether you still
> want this URL to be valid? (For example, it dispalyed as "Hello" and it's
> internal URL was http://www.mydomain.com/hiddendata, do you still want
> http://www.mydomain.com/hiddendata stored somewhere in Excel or it could
be
> delete, you just want it be displayed as "Hello"?)
> Based on my scope, unfortuantely, this behavior is by design in Excel. As
> we all known, when you type an entry in your worksheet that begins with
any
> of the following prefixes (http://, www., ftp://, mailto:, file://, news:,
> \\), Microsoft Excel automatically creates a hyperlink. Also, I am afraid
> there is no options in Reporting Services could be used to realize such
> functionality.
> However, I think the following KB might be help in Excel side, but you
will
> have to do it manually
> XL2002: How to Prevent the Automatic Creation of Hyperlinks
> http://support.microsoft.com/kb/291209/EN-US/
>
> Thank you for your patience and corperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||Hi Melissa,
As I have said that it was by design in Reporting Services to export to
Excel and there is no options available doing so, I am afraid there is not
a better way doing this except two workaround below, which seems rather
Ugly :(
First of all, you will have to change your raw data from http://www... to
'http://www...
Secondly, write the marco codes as KB:Q291209 described and save the file
in C:\Program Files\Microsoft Office\OFFICE11\XLSTART (in case you are
using Office 2003, if not, you will find the correct path to put the file
to be loaded when Excel started in KB:Q291209). Even if you have put this
marco to be loaded automatically, the excel file will still be open as all
hyperlinks available, the links will be invalid as expected only when it
get the focus and then lose the focus.
AGAIN, I understood that neither of the workaround seems done a good job,
however, regarding this by design issue, I really appreciated your
understanding that we do not have such funcationality directly and
beautifully.
If you have any questions or concerns, don't hesitate to let me know. We
are here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hi Melissa,
I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. We appreciate
your patience and look forward to hearing from you!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!