Recovered my file, seemed to have fixed it now but whenever i go to the layout with the new calculation it freezes. I'll tweak and hope i can make it work.
Perhaps you should post your calculation. Sounds like a recursive calculation that lacks an exit condition.
This happened to me a couple of times - 80,000 thousand new records later and I figured it out. I put Exit If (x>20) helped me control what was going on until I knew what my real Exit If clause would be.