Product:
Planning Analytics 2.1.19 for excel
Microsoft Windows 2022 server
Issue:
In a PAFE (PAX) report where a cell have a formula with @DBRW the cell is not updateable, you have to write the full value again. Is there a way to edit the text in a cell without destroying the formula?
Solution:
Place the cursor in the cell to update.
In Excel press F2 followed by F9 and then edit text in cell, press enter when done.
If you publish the excel report to TM1WEB, then in TM1WEB you can edit the cell direct and the values are stored in the cube.
More Information:
https://blog.quebit.com/blog/quebit-blog-mastering-the-tm1-dbrw-excel-function
https://www.wimgielis.com/tm1_articles_EN.htm
https://www.ibm.com/docs/en/planning-analytics/2.1.0?topic=view-editing-data-in-cube-cells
https://www.ibm.com/docs/en/planning-analytics/2.1.0?topic=websheets-websheet-overview
https://www.howtogeek.com/dont-ignore-the-power-of-f4-in-microsoft-excel/