Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

8 Answers

  • Best Answer
    Posted on Jan 05, 2011 at 07:09 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 17, 2014 at 11:59 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 12, 2011 at 03:15 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 01, 2011 at 06:16 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 12, 2011 at 10:26 AM

    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?!?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 27, 2014 at 03:51 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 02, 2014 at 10:29 PM

    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/

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 12, 2014 at 11:45 AM

    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)

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.