@Zuhuri
Without accurate information and the file (without sensitive data) one can only make assumptions. Here are some of them... without guarantee :).
Excel macros that protect and unprotect worksheets may run slowly
Symptoms
Macros in Microsoft Excel 2013 run slower than in earlier versions of Excel. For example, you may notice that .xlsm files open very slowly or that it takes a long time to move to the next cell when you enter data in cells.
Cause
Because of a new, stronger hashing algorithm (SHA-512) for encryption in Microsoft Office 2013, macros that protect worksheets and unprotect worksheets run slower if they protect or unprotect several worksheets sequentially.
Resolution
This behavior is by design. It's not noticeable when you're manually protecting a worksheet. However, if you have code that protects or unprotects work sheets repeatedly, this behavior can cause a performance issue.
More Information
The delay is caused by a stronger hashing algorithm (SHA-512) than is present in earlier versions. (The default hashing algorithm to protect files by requiring a password in Office 2010 is SHA1.) This change can cause a performance issue for some Office developers.
you can try with VBA...
instead of VBA try first manual...you could turn it off and try if it got faster.
...How Excel determines the current mode of calculation
Or
...you have to go into the VBA code and turn off the automatic calculation if necessary.
Private Sub Workbook_Open()
Application.Calculation = xlManual
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.Calculation = xlAutomatic
End Sub
Please note that if you turn off the automatic calculation, the results will be correct after you close and reopen the file.
Hope I was able to help you with this info.
NikolinoDE
I know I don't know anything (Socrates)
Was the answer useful? Mark them as helpful!
This will help all forum participants.
