2 Replies Latest reply: Aug 24, 2012 10:50 AM by Julian Patmore RSS

SAP GUI 730 and Excel 2010 date issue

Julian Patmore
Currently Being Moderated



We are in the process of upgrading to Excel 2010 and SAP GUI 730, I am currently running some tests and have hit an issue.


When we look at a table in an ALV grid (eg se16n) and then click Excel Inplace if there are any date values it converts them into a number format rather date.


As an example 04.12.2008 displays as 39786 within excel.


I can run a macro to convert it put it doesn't make for a good user experience etc.


I have looked in the trust centre and enabled "trust access to the VBA project object model" but still no joy.


Our build is

Windows XP 32bit

Office 2010 32bit



Any help would be appreciated.