[Ow...] Posted June 3, 2022 Share Posted June 3, 2022 Just upgraded to Calypso 7.2.08 (2nd service pack loaded) and I'm getting this error after a program finishes and it won't develop an excel report. I can't find any Microsoft subdirectory with an xlstart? Seems like I seen something posted about this here but, damned if I can find it in the search operation. Link to comment Share on other sites More sharing options...
[Er...] Posted June 3, 2022 Share Posted June 3, 2022 viewtopic.php?t=3670 viewtopic.php?f=13&t=4412 Link to comment Share on other sites More sharing options...
[Ow...] Posted June 3, 2022 Author Share Posted June 3, 2022 That post defines the problem and according to him it was because the ReportINI.xls file isn't in the same folder as your excel report file. My ReportINI.xls is in the same folder and it still doesn't work. 🙄 Link to comment Share on other sites More sharing options...
[Er...] Posted June 6, 2022 Share Posted June 6, 2022 Wow. Microsoft has made this difficult 😉 https://support.microsoft.com/en-us/off ... 5f1d292c19 Link to comment Share on other sites More sharing options...
[Ow...] Posted June 7, 2022 Author Share Posted June 7, 2022 Appreciate the reply Erik. I've messed around with putting the INI in the xstart file with little luck. It just opens up the INI file for everything and Calypso still can't use it. Time hasn't been on my side lately, toooo much other stuff having to deal with other than the CMM that doesn't use Excel for every program but, it's frustrating that everything worked fine before the upgrade to 2021. Link to comment Share on other sites More sharing options...
[Er...] Posted June 7, 2022 Share Posted June 7, 2022 Maybe try setting the Excel Default Personal Templates Location to a public folder and add the folder to the Trusted Locations? Then have the templates there? It could also be the Excel VBscript is set to different directories/files. Does 2021 include new Excel files with updated scripts? Link to comment Share on other sites More sharing options...
[Ow...] Posted June 16, 2022 Author Share Posted June 16, 2022 Well, finally got around to running a program I needed the excel report on and figured this out. It wasn't the .INI file at all, it was that the file it was searching for was named Characteristic11.xlt, which was in calypso\data\excel_report\ file path but was one I hadn't used in 4 years. The correct one that I have been using is just the normal Characteristic.xlt (without the 11). Reselected the Characteristic.xlt and it worked fine. What's weird is that every program I have opened so far that has been set up and run successfully over the years with the Characteristic.xlt , now looks for the Characteristic11.xlt after upgrading to 2021 7.2.08. 😕 Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in