Posted: Mon Sep 12, 2011 10:06 am Post subject: Выгрузка отчёта в Excel 2010
Добрый день!
Столкнулся с проблемой: не выгружаются отчёты в Excel 2010. Выгрузку делаю стандартным функционалом, через формат отчёта. Безопасность макросов настроил, в Excel 2003 и 2007 всё выгружается.
Age: 170 Joined: 04 Oct 2007 Posts: 1218 Location: Санкт-Петербург
Posted: Mon Sep 12, 2011 9:41 pm Post subject:
Вы собираемся ставить новый офис, на глаза попадался документ, что в sap нужно темплайты менять.
Quote:
Dear All,
This is to provide you with the solution to the issue reported during the testing of the SAP systems with alpha and beta image @MyPC image (Windows7 + MSOffice2010).
Symptoms (Issue):
The standard "Excel In-Place" functionality in SAP GUI does not perform as expected, the excel screen is called without any values passed; excel screen comes empty.
Reason:
Due to restricted security settings in the "Trust Center" of the MS Excel 2010, the macro could not run and fill in the values in the Excel view.
The solution:
The corrections are described in SAP notes 1292970, 1296825 and 548409
Correction Instructions:
Import the updated excel templates into the SAP Backend system (Dev) system. (sap_sm.xls and cus_sap_sm.xls)
The template is attached to this note, unzip the file to the relevant directory (or you can download from referenced SAP notes directly).
The custom template is imported into the system using the report 'BCALV_BDS_MAINTENANCE'.
To do this, choose "Import templates" on the selection screen and start the report.
If your system is on transport path, you must select the "Set to transport request" check box on the selection screen.
For importing the custom template choose the arrow next to the "Upload templates" button in the function key bar and select the standard customer templates.
After you enter relevant directory on the local PC and the name of the templates (SAP_SM.XLS and CUS_SAP_SM.XLS) the template is copied to the system.
Pleae repeat for both templates.
Warning, Known issues, System behaviour after corrections:
• Please note, that due to restricted security settings in GPO (in the image) the user will be asked to enable macros in the Excel screen each time in order to import or refresh data, for example if sort order is changed. In default settings the Excel prompt displays in separate window (not in SAP GUI screen). This can be avoided by selecting "Trust all from publisher" the first time.
• Please note, that the certificate within the Excel macro currently is only valid until November 2011. Having said that, expect the new version to be released by SAP in coming months (will also be included in Support Packs).
_________________ Молитва - это запрос разработчику на изменение кода программы.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum
All product names are trademarks of their respective companies. SAPNET.RU websites are in no way affiliated with SAP AG. SAP, SAP R/3, R/3 software, mySAP, ABAP, BAPI, xApps, SAP NetWeaver and any other are registered trademarks of SAP AG. Every effort is made to ensure content integrity. Use information on this site at your own risk.
