Jun 04 2022 08:33 PM
Jun 04 2022 08:33 PM
I've been having a HORRIBLE time with excel since having to use an excel sheet with macros for a new retail partner. Without using their excel sheet my excel runs slow and it is causing major problems for me. Can someone please advise how to make it run better?
Jun 05 2022 01:32 AM
Without accurate information and the file (without sensitive data) one can only make assumptions. Here are some of them... without guarantee :).
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.
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.
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.
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.
...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.
I know I don't know anything (Socrates)
Was the answer useful? Mark them as helpful!
This will help all forum participants.