Troubleshooting
Problem
In an update of Microsoft Office 365, Microsoft upgraded Excel's formula language to support dynamic arrays. Part of this upgrade adds the `@` symbol in front of certain formula types. In general, this upgrade should not cause any problems in IBM Planning Analytics for Microsoft Excel, however if the Internet and network paths with hyperlinks setting is also enabled, this upgrade will impact certain TM1 functions in Planning Analytics for Microsoft Excel. For more information about Microsoft's upgrade to Excel's formula language, see Implicit intersection operator: @.
Microsoft Excel by default enables Internet and network paths with hyperlinks, an AutoCorrect setting which automatically turns text that represents Internet and network paths into hyperlinks. This setting may interfere with TM1RPTROW functions.
Symptom
If the Internet and network paths with hyperlinks setting is enabled, you might experience difficulties double-clicking a TM1RPTROW function. You might be prompted to send an email, rather than the function expanding and collapsing.
Resolving The Problem
Follow these steps to disable the Internet and network paths with hyperlinks AutoCorrect setting:
- Open Microsoft Excel.
- Click .
- Click AutoCorrect Options....
- Click the AutoFormat As You Type tab.
- Uncheck Internet and network paths with hyperlinks under Replace as you type.
Note: For TM1RPTROW functions that were already converted into hyperlinks, remove the link and republish the report to remove the hyperlink from published reports:
- Right-click the TM1RPTROW function that contains the hyperlink.
- Click Edit hyperlink.
- Click Remove link.
Document Location
Worldwide
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSD29G","label":"IBM Planning Analytics"},"ARM Category":[{"code":"a8m0z000000GoRcAAK","label":"Troubleshooting->Planning Analytics For Excel"}],"ARM Case Number":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
07 April 2020
UID
ibm16172479