Had a template that I needed to run TM1 Print Report on, but kept failing with "Print Report-Delete method of Worksheet class failed" - turned out to be a sheet that was flagged as Visible:=2-xlSheetVeryHidden.
Changed to visible and deleted in my case-all fine now.
Seemed fine if set to 0-xlSheetHidden but Print Report does not like xlSheetVeryHidden.
Delete method of Worksheet class failed
-
ngphong
- Posts: 7
- Joined: Thu Jun 22, 2017 5:17 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 365
Re: Delete method of Worksheet class failed
Thank you so much for this postings. It's very helpful. It worked for me when I changed the Visible to "0-xlSheetHidden" on the "Cognos_Office_Connection_Cache" which was not visible. It only shows on the VBA window of Developer menu.