Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-901310%22%20slang%3D%22en-US%22%3EPerformance%20issues%20%3A%20Excel%202016%2064%20bit%20with%20Windows%207%20Vs.%2010%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-901310%22%20slang%3D%22en-US%22%3E%3CP%20class%3D%22%22%3EHello%20Team%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20are%20facing%20some%20performance%20issues%20with%20Windows%2010%20with%20Excel%202016%2064%20bit.%3C%2FP%3E%3CP%3EOur%20testers%20observed%20that%20the%20calculation%20in%20the%20excel%20application%20is%20taking%20much%20time%20when%20compared%20with%20Windows%2010%20vs.%20Windows%207%20with%20same%20Excel%20Version%20and%20Application.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20are%20the%20results%20%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3BWindows%207%20%26amp%3B%20Excel%202016-64bit%3C%2FP%3E%3CP%3E%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3C%2FP%3E%3CP%3EScenario%20%23%201-General%20-%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E21%20seconds%3CBR%20%2F%3EScenario%20%23%202-(With%20Calculation)%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E-%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E156%20seconds%3CBR%20%2F%3EScenario%20%23%203-(Without%20Calculation)-%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E32%20seconds%3C%2FP%3E%3CP%3ESame%20Scenarios%20on%20Windows%2010%20taking%20much%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWindows%2010%20%26amp%3B%20Excel%202016-64bit%3C%2FP%3E%3CP%3E%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3C%2FP%3E%3CP%3EScenario%20%23%201-General%20-%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E36%20seconds%3C%2FP%3E%3CP%3EScenario%20%23%202-(With%20Calculation)%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E-%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E342%20secs%3C%2FP%3E%3CP%3EScenario%20%23%203-(Without%20Calculation)%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E-%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E64%20secs%3C%2FP%3E%3CDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20suggest%20what%20might%20be%20the%20problem%20fix%20we%20need%20to%20apply%20for%20reducing%20the%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3EMadhu%3C%2FP%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-901310%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-901652%22%20slang%3D%22en-US%22%3ERe%3A%20Performance%20issues%20%3A%20Excel%202016%2064%20bit%20with%20Windows%207%20Vs.%2010%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-901652%22%20slang%3D%22en-US%22%3E%3CP%3EPrcesiely%20what%20are%20these%20scenarios%3F%20And%20precisely%20what%20is%20taking%20this%20amount%20of%20time%3F%20A%20recalculation%2C%20opening%20a%20file%2C%20running%20a%20macro%2C%20something%20else%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-901673%22%20slang%3D%22en-US%22%3ERe%3A%20Performance%20issues%20%3A%20Excel%202016%2064%20bit%20with%20Windows%207%20Vs.%2010%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-901673%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Especifically%20its%20related%20to%20running%20macros.%3C%2FP%3E%3CP%3EAnd%20this%20Macros%20consists%20of%20filling%20of%20cell%20values%20from%20another%20referenced%20cells%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
madhukar4086
New Contributor

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 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 seconds
Scenario # 2-(With Calculation) - 156 seconds
Scenario # 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.

 

Thanks

Madhu

5 Replies

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 

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.

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

Impossible without seeing any code I'm afraid.
Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies