Hi, everybody!
We have a problem with the Excel 2007 (respectively Excel 2010) Trust center. Our application is installed in a folder and it is generating a report that is an Excel workbook. The report is placed (after it is being generated) in a sub-folder of the application’s folder. The name of this sub-folder is randomly generated by the application as well, so it is not known in advance. The application’s main folder is added to Excel’s trusted locations.
Each time the Excel report is generated for the first time, it opens in a disabled view without the ribbon and any buttons. The only way to close it is using the Task Manager. In this case I open the newly created report using Windows Explorer. The report opens normally and everything works. When I generate the report once again through our application after I had already opened it manually, it appears on the screen in the normal view – ribbon, buttons, menus, etc. are functioning and on their places.
My question is: how to tell Excel that the sub-folders of the folder (that is a trusted location) belong to the trusted location as well. Or: how could I disable the trusted locations so, that Excel would not check them, in other words Excel would accept each location as “trusted”?
Thank you.