Is this in Excel? I had a similar problem last week that VoG sorted for me. Does it give you the opportunity to Debug?
Mine was caused by renaming a sheet that must have been referred to in one of the formulas or macros. Renaming it to the original sorted it.