Excel2007/AS400 data transfer crashes during download

Posted on 2007-07-31
Last Modified: 2013-12-06

I installed the cwbtfxla.xll file on a user's brand new PC this morning so she can do data transfers from our AS/400 databases into an Excel spreadsheet. It seems to work on all other versions of Excel around the office, but when I try running the data transfer in Excel2007 it does not work. She is able to enter the database and lib name, but when she  tries to run the transfer she gets the familiar IE  app crash screen, (complete with the useless options of send/ don't send to Microsoft). PC was rebooted and restarted, data transfer was attempted again and the same thing happens.  Unfortunatley, as of right now this is the only PC in the office that has Excel2007 on it, so it is not yet possible for me  to test it on a different computer.

Does anyone know if there are any known bugs  with this new version of Excel which will cause this? Does anyone know of any remedies or fixes?  Thanks
Question by:SHSadmin
    LVL 10

    Expert Comment

    LVL 10

    Expert Comment


    Author Comment

    It turns out that the base release of ISeries Access V5.R4 is not current enough to work with  Office 2007.  We needed to download  the most recent service pack available.  As of this writing it is SI27741.  It contains the Data Transfer fixes and once I installed it, it fixed the problem.
    LVL 1

    Accepted Solution

    PAQed with points refunded (125)

    EE Admin

    Expert Comment

    In 3 installations of Office 2007, the iSeries data transfer in Excel would crash. The solution in each case was to install Office 2007 Service Pack 1, after which the transfer data from iSeries add-in worked fine.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    In a recent article here at Experts Exchange (, I discussed my nine-month sandbox testing of the Windows 10 Technical Preview, specifically with respect to r…
    #Citrix #POC #XenDesktop #vCenter #VMware #ESX
    This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
    This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now