Sheet update extremely slow

[bibleguy125]

Hey all,
I have a macro that updates a worksheet with an inventory downloaded from our company program. I have it set up to update if it is opened, open the file and update if not, or tell you that the file does not exist if that is the case.

My only problem is when it opens the sheet itself it works, but goes incredibly slow, like a cell at a time for the entire inventory, which takes like 15 minutes, and its only about 300 lines. Does anybody know why it would be going so slow or how to fix it?

When updating from the open sheet it is almost instantaneous.

[Domski]

Hi,

It would probably help to see your code.

Turning screen updating off and controlling calculation modes while the macro is working may help.

Dom