Problems with formula and Excel report

I have following formula:

IF(
LEN( GPS_Customer__c ) > 0,
HYPERLINK("/" & GPS_Customer__r.Id , GPS_Customer__r.Name__c ,'_self'),
""
)

Explanation:

If customer (lookup) is given to object "Time entry", let's generate "Customer name" hyperlink which points out to customer object (custom object).

(Customer ID is autonumerated field (CUS-{0}) and therefore i have created this another formula field to hide cryptic ID from application users)

Everything works well at salesforce:

Testcompany Ltd link points out to proper record at Salesforce.

But when i export report into Excel:

Customer name field is not working anymore.

Expected result should be: Testcompany Ltd without link

Suggestions how to tackle this without creating another custom formula field called "Customer link"?

Thanks in advance.

Need an account? Sign Up

Have an account? Sign In