Something really frustrating about Planning Analytics for Excel Dynamic Reports is that sometimes the row titles get converted to hyperlinks that try to open your email application when you click on those row titles. The row titles are generated by the TM1RPTROW function and with the addition of arrays in Excel this became an issue.
Stopping Mailto in Planning Analytics for Excel Dynamic Report
To stop a hyperlinks appearing on rows in a Dynamic Report is dead easy. Just:
- Open Excel
- Go to File, Options, Proofing
- Select the AutoCorrect Options
- Then select the AutoFormat As You Type tab
- Uncheck the Internet and network paths with hyperlinks box
You will then need to restart Excel.
Remove Hotlinks in an Existing Dynamic Report
After doing the above, if you have an existing Dynamic Report with hotlinks, you will need to remove them manually. To do this:
- Select the TM1RPTROW formula and the rows beneath that have the hyperlinks.
- Right click and select Remove Hyperlink
- Then Rebuild your Dynamic Report
There doesn’t appear to be a requirement to change anything in the Format Area of the Dynamic Report.
Thanks!
Thanks heaps to Nicole Joreid from IBM for sending these instructions through to me!
Do You Need Help with a Dynamic Report?
If you have any questions about Dynamic Reports, please get in touch. We’d love to help you.