Excel Add-in Slowness

Hello, we are using Excel Add-in ver 10.0.7 with Lawson 10. I have a customer trying to load 147K records using the add-in to IC11, and she complained that is extremely slow compared with old add-in 9.0.x that she was using. Has anyone experienced similar issue? And if you have, any work around?

My environment:
Windows 7 32-bit, Office 2016 32-bit.

Thanks,
Dong

Find more posts tagged with

Infor Lawson Supply Chain Group - Discussion

Comments

lxiong3

Using the "Enabled Multi-Threaded Requests" seems to help; only if the data does not need to be loaded in sequence.

0911060553270289.pdf

unknown

Thank you. I checked that option this morning, and waiting to see how long will it take to upload 147K records. It may time me out before finish. Is there a way to change timeout setting on Add-ins?

unknown

When we have files that large we upload after hours. Of if they need to be done during the day, it works best to break the uploads up a bit. 147K files is pretty heafty.

unknown

Top left hand corner green and yellow arrow heads - enter new time limit (default 60)

unknown

That is true, I could break up the spreadsheet. I also know functional users have a reason or two to keep it intact. Thank you.

unknown

Thank you. I will try that. Right now, it is locked waiting on uploads.

taliening

We have the same experience with IC11. Breaking up the file might help keep it from crashing. Haven't found a way around it, even attempted to turn off Item Master Audits when loading. None of which significantly helped. We have case open with support.

unknown

Thanks for the info. I tried to limit rows to change. It worked with 20K records that took about 3 hours, with multi-thread turned on.

-Dong

Copyright © 2025 Infor. All rights reserved.