IBM i Global

 View Only
  • 1.  ACS Data Transfer Error Active SpreadSheet not found

    Posted Wed September 21, 2022 11:10 AM
    For some reason, on Windows 11, java.version: 1.8.0_341, Excel Build 15601.20148 does not allow data transfer using ACS Version: 1.1.9.0 to active excel spreadsheet and throws the below error. 

    IBM support says they are unable to reproduce error and asking to reimage Windows. I am curious to know if anyone in the community faced such problem and what was the solution approach. 

    We tried ACS finest logging and ProcMon logging as per IBM. Nothing could be determined as a root cause. Guidance is much appreciated.

    Thanks, 
    Krishna



    ------------------------------
    Krishna Kumar Thulasiraman
    ------------------------------


  • 2.  RE: ACS Data Transfer Error Active SpreadSheet not found

    Posted Wed September 21, 2022 08:56 PM
    Dear Krishna

    I did a Google search with "ibm i acs spreadsheet not found" and found this Technote that appears to address your problem : 'Active spreadsheet was not found' With IBM i Access Client Solutions Data Transfer  

    Another way you can use is  Importing Data To Excel Using ODBC

    IBM i Access Client Solutions (ACS) Data Transfer Download to Excel Spreadsheet




    ------------------------------
    Right action is better than knowledge; but in order to do what is right, we must know what is right.
    -- Charlemagne

    Satid Singkorapoom
    ------------------------------



  • 3.  RE: ACS Data Transfer Error Active SpreadSheet not found

    Posted Thu September 22, 2022 09:52 AM
    Hi Satid, 

    I had already went through troubleshooting steps with IBM. Posted in the community to check if anyone has come across such issue. 

    IBM is not able to replicate the scenario.

    Thanks,

    ------------------------------
    Krishna
    ------------------------------



  • 4.  RE: ACS Data Transfer Error Active SpreadSheet not found

    Posted Fri September 23, 2022 08:53 PM
    Dear Krishna

    In such a case, it is more likely the problem you encounter lies in Excel than in ACS.  You should try searching Microsoft support information instead.

    ------------------------------
    Right action is better than knowledge; but in order to do what is right, we must know what is right.
    -- Charlemagne

    Satid Singkorapoom
    ------------------------------



  • 5.  RE: ACS Data Transfer Error Active SpreadSheet not found

    Posted Mon September 26, 2022 09:51 AM
    I have had an issue with transfer to/from a spreadsheet in Mac OS Monterey and ACS 1.1.8. I ended up using another product (Razor).

    ------------------------------
    Chris McNierney
    ------------------------------



  • 6.  RE: ACS Data Transfer Error Active SpreadSheet not found

    Posted Mon September 26, 2022 09:56 AM

    I tried repairing O365 Online. I did this action earlier locally but it did not workout.

     

    When I did the step online and restarted office – it worked without any issue.

     

    Thanks,

    Krishna

     






  • 7.  RE: ACS Data Transfer Error Active SpreadSheet not found

    Posted Sun September 25, 2022 10:50 PM
    When I have encountered this issue, it has usually been fixed by running Repair on Excel

    ------------------------------
    Peggy Kimbell
    ------------------------------