Discussion
Bank of New York Mellon
US
Last activity: 31 Mar 2015 14:18 EDT
Blank Project Sizing Spreadsheet
I uploaded specifications and I can see them in the tool. When I try to create a Sizing spreadsheet, nothing is exported to Excel. I open the App Overview, click Generate Sizing, then click the Create Project Sizing, the spreadsheet opens, I click Enable Editing and get prompted to Enable macros which I do but nothing is populated in the sheet.
Pegasystems Inc.
US
Hi Susan,
I tested the scenario you described. I do not have a running copy of Pega 7.1.5 so I am using a Pega 7.1.4 image and I was able to successfully generated the Sizing Spreadsheet.
When you clicked on the "Create Project Sizing" button on the "Sizing Application" landing page, which "Implementation methodology" did you have selected. Also, which version of Microsoft Excel do you have installed on your work station? Pega 7.1.5 is only compatible with Microsoft Excel versions 2003, 2007, and 2010.
Regards,
Henry
Pega Academy
Bank of New York Mellon
US
Hi: okay, it's working now. I saved it down first and then opened it and that seems to have worked. I did try this strategy yesterday but it didn't work. I also played with Macro Security just now and now I get an error if I just create and open the sheet without saving--Run-time Error '1004': Method 'sheets' of object'_Global' failed. I was not getting that yesterday. But since saving it down and then opening seems to be working, I'm okay now.