TM1 Forum

Is it possible to change the formatting when drilling from Excel? I have learned that when drilling to a cubeview from Excel a fresh Active form is used. I know Active forms can be formatted. I have not been able to find out how to set the formatting for the "fresh" Active form that is used when drilling from Excel. The default format is creating issues as certain rows and columns are using the same color for text and background (the cells look empty).

I am using version 9.5.2 and Excel 2007.

Thanks for any information.

Mack

There might be others but the only product I know of to do this is the Cubewise Extend Excel add-in.

just a thought and I have not tried, but could you change the default styles in excel
http://www.pchelps.com/2011/03/producti ... ormatting/

Thanks for the idea of changing the default styles in Excel. Unfortunately the "fresh" Active Form default style overrides the formatting in the Book.xlxt file from the XLSTART directory.

Hi

If you can use VBA then you can do this by using VBA to trigger the drill. Once you can do that, you can then use VBA to format the resulting sheet. I did a previous post on how to do this. However, if you are deploying this via TM1 Web then VBA is not an option.

Regards

Paul

The problem is that it appears the formatting for the active form is hard coded into the XLA. I tried to figure out a way to change it when active forms first came out but was never able find anything, thus coming to the conclusion it was in the XLA. I find that very annoying and quite amateurish on IBM's part. It wouldn't have been that difficult to expose that to developers so that we could have our own default formatting. The default ones built in are a joke, IMO.

Paul, thanks for the VBA idea. We are going to give this a try as we have not found any other solution to this point.

Tom, I agree it would have been nice for IBM to expose this to developers. Is it possible for useres to have different versions of the XLA file? We are finding that drill formatting is not the same for all of our users. Most users receive the formatting with the text the same color as the backgroung, but a few receive formatting with automatic text color. We could live with that formatting option if it could be deployed to all users.

hallma wrote:Is it possible for useres to have different versions of the XLA file?

I suppose it's technically possible (BTW, the code is actually in the XLL) but the problem is IBM only provides the one that comes in the install. You would have to ask them to create a special one just for you. Don't see that happening.