on 08-17-2012 3:21 PM
Hi
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
SAP GUI 730
Any help would be appreciated.
Thanks
Julian
Hi
How now resolved this by installing Service Pack 1 for Office 2010.
Thanks
Julian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Julian,
I tested this with Table MARA in SE16N and the date shows in the correct format with
SAPKB70211
Same with,
SAPKB46C64
What is the basis level you are testing with?
Regards,
Jude
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.