Dear Forum,
Can I set one file to Manual calculation while leaving the others in Automatic calculation mode? I have an excel file that takes too long to calculate.
Thanks in advance
Dear Forum,
Can I set one file to Manual calculation while leaving the others in Automatic calculation mode? I have an excel file that takes too long to calculate.
Thanks in advance
Hi,
You can do this by changing the workbook into a XLSM file and adding two event procedures in Visual Basic Editor (ALT+F11 to open):
If you are not familiar with VBA this will be a little difficult but not too much!![]()
Private Sub Workbook_Open() Application.Calculation = xlCalculationManual End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.Calculation = xlCalculationAutomatic End Sub
Diana Tanase
If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks