Forum Discussion
Wojciech_Plonka
Mar 23, 2021Copper Contributor
My formulas don't refresh automatically
Hi, I have the following problem (I tried google and this forum but found nothing): I have an external software writing text values to my excel column, and it's working fine. I have around 1400 r...
Wojciech_Plonka
Mar 24, 2021Copper Contributor
doesn't work
NikolinoDE
Jul 13, 2021Gold Contributor
Try VBA, it may be the solution for you.
The automatic calculation in the excel workbook should be activated every time it is opened.
VBA Code:
Private Sub Workbook_Open()
With Application
.Calculation = xlAutomatic
.CalculateBeforeSave = False
End With
End Sub
Always at your services
Nikolino
The automatic calculation in the excel workbook should be activated every time it is opened.
VBA Code:
Private Sub Workbook_Open()
With Application
.Calculation = xlAutomatic
.CalculateBeforeSave = False
End With
End Sub
Always at your services
Nikolino