Picklist in reports

Post Reply
kavitha2002
Community Contributor
Posts: 180
Joined: Sat May 05, 2018 11:48 am
OLAP Product: tm1
Version: 10.3.10100.8
Excel Version: 14

Picklist in reports

Post by kavitha2002 »

I have a picklist in Excel reports, it always prompt for the Save dialog box when I close the report in my application.

In the code I have given "Thisworkbook.Saved = True", its work well until I chose the value from picklist. When I choose the value from picklist, its prompt with "Save Dialog box" .

I dont want to show the Save Dialog box. Any Idea how to resolve this?
ellissj3
Posts: 54
Joined: Tue Jun 15, 2010 1:43 pm
OLAP Product: Cognos TM1
Version: 9.0 - 10.2
Excel Version: 2010

Re: Picklist in reports

Post by ellissj3 »

This isn't necessarily a planning analytics question. If macros are on the table, then put together an On Event routine to handle this (flagging the document.saved=true). Otherwise, stand this up as a template file on the Applications and tell your users to ignore it :D
kavitha2002
Community Contributor
Posts: 180
Joined: Sat May 05, 2018 11:48 am
OLAP Product: tm1
Version: 10.3.10100.8
Excel Version: 14

Re: Picklist in reports

Post by kavitha2002 »

Hi ellissj3,

I am not using macros, using Action Reports. I have tried with Workbookbeforeclose Event and sheetchange Event, but its not getting triggered on the picklist value change. Its badly disturbing our application prompting with Save Dialog .. so any other workaround on excel??
Post Reply