Forum Discussion
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...
Numbers formatted as text
Solve, in that case you just have to mark all affected cells with the mouse.
Then you click with the right mouse button on the marker.
Select Format cells from the context menu.
In the following window choose from the formats standard or number.
Confirm with OK and Excel should do the math again.
Solve, in that case you just have to mark all affected cells with the mouse.
Then you click with the right mouse button on the marker.
Select Format cells from the context menu.
In the following window choose from the formats standard or number.
Confirm with OK and Excel should do the math again.
doesn't work
- 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