IBM Support

Unable to expand/collapse on TM1RPTRow in a Dynamic Report (shows the mail to icon)



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.


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:
  1. Open Microsoft Excel.
  2. Click File > Options > Proofing.
  3. Click AutoCorrect Options....
  4. Click the AutoFormat As You Type tab.
  5. 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:
  1. Right-click the TM1RPTROW function that contains the hyperlink.
  2. Click Edit hyperlink.
  3. Click Remove link.

Document Location


[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"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"}}]

Document Information

Modified date:
07 April 2020