Delete method of Worksheet class failed

Ideas and tips for enhancing your TM1 application
Post Reply
User avatar
gtonkin
MVP
Posts: 647
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL 2.0.3
Excel Version: 2016 64-bit
Location: JHB, South Africa
Contact:

Delete method of Worksheet class failed

Post by gtonkin » Mon Aug 28, 2017 1:04 pm

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.

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

Post by ngphong » Tue Feb 12, 2019 12:50 am

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.

Post Reply