In a remote IBM environment that we can provision for customers, I am trying to look at how to clear a sheet.
But it does not do it.
- Capture.PNG (77.83 KiB) Viewed 1257 times
Thanks a lot.
Clear sheet in PAFX
-
Wim Gielis
- MVP
- Posts: 3233
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.1.5
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Clear sheet in PAFX
Hello,
In a remote IBM environment that we can provision for customers, I am trying to look at how to clear a sheet.
But it does not do it.
Nothing happens, the DBRW's survive, no cells are cleared. Does anyone have this working ? It's version 2.0.50 and PAW 2.0.48
Thanks a lot.
In a remote IBM environment that we can provision for customers, I am trying to look at how to clear a sheet.
But it does not do it.
Nothing happens, the DBRW's survive, no cells are cleared. Does anyone have this working ? It's version 2.0.50 and PAW 2.0.48
Thanks a lot.
Best regards,
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
Paul Segal
- Community Contributor
- Posts: 312
- Joined: Mon May 12, 2008 8:11 am
- OLAP Product: TM1
- Version: TM1 11 and up
- Excel Version: Too many to count
Re: Clear sheet in PAFX
Hi Wim,
Try using Snapshot, Sheet instead. This will clear TM1, er, PAfE formulas and retain Excel only ones.
Try using Snapshot, Sheet instead. This will clear TM1, er, PAfE formulas and retain Excel only ones.
Paul