Functions Cannot Work after Syncronised

[FangYR]

Hi everyone,
I syncronised some excel files with my pocket pc using Microsoft Activesync
4.1.. It worked alright for some time and suddenly whenever I open the file
on my computer, it gives a message asking whether I want to enable macros and
the only choice I have is to enable, but all my formulas and functions cannot
work, unless I press ENTER on the 'formulated' cell. I have also try F9 as
suggested by some, but it was already in 'auto' calculate mode.
What went wrong?
Please advise.
Thanks.

 

[exceluserforeman]

Maybe someone set the Security to Medium or High?

Tools >> Macro >> Security