Forum Discussion

madhukar4086's avatar
madhukar4086
Copper Contributor
Oct 09, 2019

Performance issues : Excel 2016 64 bit with Windows 7 Vs. 10

Hello Team,   We are facing some performance issues with Windows 10 with Excel 2016 64 bit. Our testers observed that the calculation in the excel application is taking much time when compared wit...
excel
Formulas and Functions
Macros and VBA
madhukar4086's avatar
madhukar4086
Copper Contributor
Oct 09, 2019

JKPieterse 

specifically its related to running macros.

And this Macros consists of filling of cell values from another referenced cells 

JKPieterse's avatar
JKPieterse
Silver Contributor
Oct 09, 2019
It is not unusual for code to take longer when run on a different operating system. We might be able to help you optimize the running time if you share the code.
  • madhukar4086's avatar
    madhukar4086
    Copper Contributor
    Oct 10, 2019

    Unfortunately, we cannot share the code as per the client. Please provide any other alternatives if available.

    • JKPieterse's avatar
      JKPieterse
      Silver Contributor
      Oct 10, 2019
      Impossible without seeing any code I'm afraid.
      • RobertPBenz's avatar
        RobertPBenz
        Copper Contributor
        Jan 14, 2021

        JKPieterse I have an Excel work book that polls data from a Modbus server (via MBAXP active x) The newer versions of Excel v1905 are running slower and slower.  Running a simple do while loop runs a minimum 5 times longer on the version 2012 (Build 13530.20376).  

         

        Worse yet, the new version cannot run my application.  I had to revert back to Version1902!  If you want my application Ill send it.  It is totally screwing up our business as every Windows10 unit I purchase for a customer I am required to downgrade to version 1902 or earlier!

         

        Thanks

        Bob Benz

Resources