Office 2010 BEX workbook saving
i wanted to ask. We currently are upgrading to Office 2010. Our users have the following process flow.
They open on application server a workbook in BEx analyzer. Then they download it to a network drive so they have a local version which they can edit. And then they save the local version as .xls to be able to open it without BEx or to refresh it from BEx. Now when open a workbook with Office 2010 on server and save it locally on networkdrive. If user edit the excel sheet and want to save it back my question is in which format should it be saved.
In office 2010 we have many possibilities like macro enabled or the normal office 2010 format or excel97 2003 workbook format. But it brings a n error when you want to save. The only way to save without an error is excel97 - 2003 workbook format. But that is not wished because we should use one of the new excel 2010 formats with the functionality.
Is there any OSS message or SAP recommendations how to handle ?
I would appreciate if someone can give nme some hints.
Thanks and regards,