Do you mean the formulas stay there and don't do anything?

But when you edit them they work? Then probably those cells have been formatted as text

Format as General and hit enter

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post