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 with Windows 10 vs. Windows 7 with same Excel Version and Application.
Here are the results :
Windows 7 & Excel 2016-64bit
Scenario # 1-General - 21 secondsScenario # 2-(With Calculation) - 156 secondsScenario # 3-(Without Calculation)- 32 seconds
Same Scenarios on Windows 10 taking much time.
Windows 10 & Excel 2016-64bit
Scenario # 1-General - 36 seconds
Scenario # 2-(With Calculation) - 342 secs
Scenario # 3-(Without Calculation) - 64 secs
Please suggest what might be the problem fix we need to apply for reducing the time.
Prcesiely what are these scenarios? And precisely what is taking this amount of time? A recalculation, opening a file, running a macro, something else?
@Jan Karel Pieterse
specifically its related to running macros.
And this Macros consists of filling of cell values from another referenced cells
Unfortunately, we cannot share the code as per the client. Please provide any other alternatives if available.