Product:
Planning Analytics 2.0.9.19
TM1 perspective
Microsoft® Excel® for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20550) 32-bit
Issue:
Then create a websheet with formulas, when it refresh the formulas change to =@TM1RPTROW.
Excel will treat any value containing an @ as an email address.
Solution:
For a single cell right click and go down the menu which appears to link -> “remove hyperlink.”
Release mouse and the hyperlink is disabled in that cell.
To prevent it to happen in future:
Go to menu File > Options > Proofing > AutoCorrect Options > Click Tab AutoFormat As You Type > Uncheck Internet and network paths with hyperlinks > OK
More Information: