Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Bex WB created in Excel 2013 can only be opened in Excel 2007 and vice versa


I do have a very strange system behaviour, where I have no more ideas of how to overcome it.

I do have workbooks which were created some time ago.

Now I needed to do some small changes - add nav attributes to free char and include them to the navigation block.

When I do this with Excel 2013 and GUI 7.3 it seems to work.

But, after I close the WB and open it again, it runs forever and when I close excel, I get an error message, that Bex is closed because of critical errors.

But if I try to open this WB on another PC with Excel 2007 and same GUI, it works.

If I now save the WB again in Excel 2007, the same problem apears - only the other way around. I can´t open the workbook in Excel 2007 anymore, but I am able to open it in Excel 2013.

The workbook does have macros inside, most of them are macros, that run in a lot of workbooks, where I don´t have this trouble when saving changes.

I even tried to open the same workbook from my test system and saved it back to development. I did this without any changes.

Same behaviour - I can´t open it in that excel version where it was saved, but I can open it with the other version.

Since the users are using either 2007 or 2013, I need something that works with both excel versions (and 2010 would also be nice).

I hope someone does have an idea about what to do.



Not what you were looking for? View more on this topic or Ask a question