Excel hyperlinks to a PPM address can't be opened on Internet Explorer

Document ID : KB000029708
Last Modified Date : 14/02/2018
Show Technical Document Details

Problem:

When using the Export to Excel feature, the links in the spreadsheet can't be opened from Microsoft Excel using Internet Explorer (IE). The number / pound sign (#) is being replaced by a dash between two spaces and the address is not opening correctly on this browser. PPM uses a URL format that contains this sign.

Environment:

Microsoft® Windows environment using Microsoft® Office and Internet Explorer versions 10 or 11.

Cause:

This is not a CA PPM issue but a Microsoft® Office issue when used with certain Internet Explorer versions, including IE10 and IE11. Microsoft® Office interprets the number sign (#) and although it is a valid character in file names and URLs, it is not accepted in hyper links in Microsoft Office documents.

Workaround:

  • Use Internet Explorer 8 or 9, an alternate browser such as a supported version of Mozilla Firefox and Google Chrome or a different Office suite to open the files with hyper links.
  • Alternatively, install Google Chrome and make it the default browser. Afterwards, Internet Explorer can be set back as the default browser and open these hyper links. It is required that the user installing Google Chrome has full administrator rights for this to work.

Additional Information:

Microsoft Article - You cannot use a pound character in a file name for a hyperlink in an Office program