TM1 Forum

Calculation is set to manual. Workbook is calculated inorder to populate with data from the cubes.

Thanks for your response.

@ lotsaram - Thanks for your response. Our seculity is CAM 5.
I will consider the sheet.copy approach. However, I do have to include a lot of macros with the workbook.

I have to generate 200+ workbooks from a master template. The VBA code to do this opens the template, then populates it with a specific id number from a list of 200+ numbers. The id number matches an id number in a dimension in a TM1 cube. The VBA code executes a TM1 Calculate which populates the wo...