SAPGUI 7.20 / Excel 2010 - Workbook is corrupt and cannot be loaded

[Former Member]

Hi all:

SAPGUI 7.20 SP 0

Excel 2010

BW 7.0

Queries run fine in Analyzer. No issues.

However, whenever we try to open a workbook saved in Excel 2007 we get this error "The workbook is corrupt and cannot be loaded".

These workbooks are executed fine from any PC with Excel 2007, same SAPGUI version (7.20 SP 0).

Furthermore, if we open a query and save a workbook (now in Excel 2010) we get the same error "The workbook is corrupt and cannot be loaded".

Basically, we can't open workbooks.

Since the only difference in both scenarios is Excel (same SAPGUI) I checked in some Microsoft forums and read something about incompatibilities in the new Visual Basic coding in Excel 2010 compared to 2007.

Other than that, nothing else so far.

Any ideas or suggestions?

Thanks in advance,

Luis

[former_member188011 · Accepted solution]

Hi Luis:

The information below was extracted from SAP Note 1498919 - "Known Limitations of BExAnalyzer with Excel 2010"

The following are the limitations of 7.0 BExAnalyzer:
1. Workbooks created with Excel 2007 having format xlsx, xlsm or xlsb, can not be opened with Excel 2010. The error message "The workbook is corrupted and cannot be loaded" is displayed instead.
Example: This issue can be observed in case of workbooks with format xlsx, xlsm or xlsb and complex definition, lot of characteristics, lot of key figures, lot of metadata stored in the workbook.

Regards,

Francisco Milán.

[Former Member · Accepted solution]

Thanks for the Note.

[Former Member]

Excel file recovery tool extract data from damaged XLS/XLSX files. It is integrated with powerful algorithm that ensures quick and complete recovery of damaged Excel files. To get more details visit here:- Excel File Recovery Tool to Repair Corrupt or Damaged Excel Files(.xls & .xlsx)

[Former Member]

Repair a corrupted workbook manually

Click the Microsoft Office Button , and then click Open.

1. In the Open dialog box, select the corrupted workbook that you want to open.
2. Click the arrow next to the Open button, and then click Open and Repair.
3. Do one of the following:
   • To recover as much of the workbook data as possible, click Repair.
   • To extract values and formulas from the workbook when an attempt to repair the workbook is not successful, click Extract Data.

If this method wasn’t effective in your case, apply Excel Repair Toolbox offered here are highly advanced and have strong built in data recovery algorithm that can produce desired results. By using this user can perform quick and accurate recovery of corrupt .XLS and .XLSX files.

Features of Excel Recovery Software-

• Recovers all types of Excel data with full accuracy.
• Recovers multiple .XLS and .XLSX files.
• Maintains data integrity of the original file after repairing the damaged Excel sheets.

  Visit:- http://www.excelrepairtoolbox.com/

[Former Member]

If you believe that your Excel sheet is corrupt, then you can

1 - Use In-Built utility to fix the corruption or you can

2 - Use third party Excel file Repair tool.

[Former Member]

Hai,

I have upload the Excel document in SAP net weaver portal. But i am unable to open the document in portal. The popup will appears 'Open' or 'Save' or 'Cancel' but i am choosing the 'Open' option but the blank IE window will appears. But other system i have checked it's able to open but in my system i am unable to open please help me...........................

Please do the needful.

Thanks,

Arun.M

[marc_ruhland]

Hi to all,

we have also the problem to open some (not all) workbooks with Excel 2010 after we have installed the newest BI Patch 500.

Check Installation on PC

Revision: 33 Computer Name: VPC1000

Check done on: 12.12.2011 10:54:48

Excel Version: Microsoft® Excel® 2010

Windows Version: Windows 7 Enterprise Edition, 32-bit (Service Pack 1)

Default Browser: Internet Explorer (8.0.7601.17514)

SAP GUI: 720 Patch 5

BI Components 7.20 Patch 500

Is there a solution for this problem or is it better to go back to Excel 2007?!?

[manna_das]

Hi,

try this SAP Note - 1435529

Regards

Manna Das

[marc_ruhland]

Hi,

this note doesn't work because we are still at front end patch level 500!

Thanks

Marc

[former_member463120]

Hi,

try this last step:

BEx Global Settings --> Default Workbook Tab --> activate the flag "use XLS file format"

Reards,

Mdeonisio

[radek_hosek2]

Hi,

This helped me:

Before save the workbook>

BEx Design Toolbox: Workbook Settings --> General --> activate the flag Use Compression When Saving Workbook

Regards

Radek

[Former Member]

Thanks Radek!

Your advice helped me also in the similar problem.

Regards,

Juha

[Former Member]

Hi,

Trying to repair the Excel workbooks in this scenario is a waste of time. I have tried all the tricks but it doesnt work. If your server falls below patch 402, then please stick with Excel 2007. Most of the time, clients are unable to upgrade due to migration requirements in BI or ERP side.

Regards,

Adeel Hashmi

[Former Member]

I solved my same problem with this solution (GUI 720, Excel 2010)

- Open Analyzer

- The system open Ms Excel, (Don't connect to BI server) -> Click Global setting icon and check "Run in repair mode".

- Connect to your BI Server and Open query or workbook that have problem.

[Former Member]

Dear Stefan,

I am also facing the same issue. Work book created in 2007 excel can not be opened in excel 2010. I tried following the steps you have mentioned changing the global settings to run repair mode before connecting to server and try connecting. But it did not work in my case. Did you apply any note? please suggest.

Thanks,

Vijaya

[former_member487208]

Dear Vijaya,

I also facing the same issue above. After install the BI add on patch level 402, it does fix the error.I can open Workbook with Excel 2010 successfully.

Thanks,

[Former Member]

Hi

I'm facing the same problem... I'm already on Excel 2010. I can save a workbook but I cannot open it anymore. I always get the following error: "The workbook is corrupt and cannot be loaded". Then, Excel 2010 crashes. The option "Repair workbook during execution" doesn't work...

I'm on "SAP GUI 7.20, Patch Level 7" and "BI Addon SP4, Patch 2, Revision 1750", i.e. I'm using the latest releases.

Can somebody help me?

[Former Member]

Hi Patrick,

I have the same problem I can open the query save the workbook but I can't open it anymore. Critical eror program.

Did you solve your problem?

thanks,

Eric

[Former Member]

Hi,

If anyone able to get the resolution for this issue, please post the solution.

Thanks,

Prateek

[Former Member]

This message was moderated.