GRC CC Risk Analysis download to Excel SE characters

[Former Member]

Hi All,

I have performed a Risk Analysis in our GRC CC5.2 and the output was good. I was able to read Swedish characters in the Internet Explorer. However, when I download the report into Excel and open the file locally from my hardware, I see the Swedish Characters as:

Anna Sjöberg (via GRC CC in IE, it display Anna Sjöberg)

Gerd Jönsson (via GRC CC in IE, it display Gerd Jönsson)

Anyone have the same display issue with Swedish characters?

Thanks.

Raymond

[Former Member · Accepted solution]

Hi Raymond,

Kindly let me know which version of Microsoft Excel are you using??

If you are using excel 2000

Check the note 1282267

Regards

Gangadhar

Edited by: gangadhar hm on Sep 4, 2009 1:08 PM

[Former Member · Accepted solution]

Hi Gangadhar,

My Excel version is 2003 SP3.

Raymond

[Former Member · Accepted solution]

Hi Raymond,

Please check the note

Note 1022187 - Compliance Calibrator 5.2 Support Pack

Can i know the SP level of CC

Regards

Gangadhar

[Former Member · Accepted solution]

Hi Gangadhar,

My GRC CC is on version 5.2_10

Raymond

[Former Member · Accepted solution]

Hi Raymond,

Thanks...

Can you check the Note 1022187 - Compliance Calibrator 5.2 Support Pack, Which gives you list of bugs has been resolved.

Secondly you can check in the ANOTHER Computer ??

Regards

Gangadhar

[Former Member · Accepted solution]

Hi Gangadhar,

Thanks so far for your help and suggestion. I have tried it on a different PC and also in Excel 2003 and 2007 and all results in the same unreadable Swedish Chars.

Anyone share the same experience?

Raymond

[Former Member · Accepted solution]

Hi Raymond,

Have you solved your problem yet?

First, save your analysis on your disk. Go to Excel>>Open file>>Chose your file >> A window pops up where you can chose encoding >> Chose UTF-8 from the list.

The swedish letters should now be properly encoded.

Best luck,

Vit