Forum Discussion

agp's avatar
agp
Cover User
2 years ago

Reports Hanging - completing OLE action

Since moving to the online files, We have found reports get stuck loading the data into Excel:

 

Microsoft Excel is waiting for another application to complete an OLE action.

 

 

MYOB has been Reinstalled and Updated.  As has Office. 

Multithreading etc are on in Office. we dont have issues when using older myob with the local file. 

 

Are there limitations to report sizes / picking the excel option etc? or any settings we need to alter to make this workable?  at the moment if we left a file to complete it would take hours instead of seconds. 

 

Thanks

 

 

  • Mike_James's avatar
    Mike_James
    Ultimate Cover User

    Hi agp , is Excel 32-bit (I'm guessing it is since the output does complete eventually)? Is AccountRight running as administrator? And was AccountRIght the last program reinstalled, which it needs to be?

    • Mike_James's avatar
      Mike_James
      Ultimate Cover User

      PS Excel should be running as administrator as well.

      • agp's avatar
        agp
        Cover User

        thanks I believe all of these were the case, But I will re run a report today with all of these paramters and confirm either way.