Excel file vba take long time to run

[SKV]

Hi all,
looking for some expert advice as I have searched everywhere but no success.

I have a large excel file ~ 80b. The file has lot of formulas and not optimized to begin with.

So while I understand the opportunity to fix the file, the THING that is bothering me is that the file takes any between 2 to 8 hrs depending upon machine to machine and day to day. This is the SAME file, all the machine have similar configuration.

I am trying understand as what system resources or excel settings impacting us that the run time is different most of the time (some times on the same machine too)

Appreciate if anyone can give any guidance so we can attain same run times.

Thanks

 

[johnnyL]

Going to be difficult to assist you without seeing the code and or file you are working with.

 

[SKV]

Going to be difficult to assist you without seeing the code and or file you are working with.

Happy to show the file over Zoom or Teams. Let me know if you are OK to spare some time and I will send you the invite. FYI - I am in EST time zone.

Also, I mentioned - this has something to do with configurations /settings of Windows and Excel. I already know that my files needs to be fixed.

 

[johnnyL]

Not interested in that, but thank you for the offer.