Pivots and Charts dont work on reopen

[robsheeds]

Pivots and Charts reopen as text: ie cant open the Field List etc... Have no links/cubes etc as stated in other posts on the net. When opening from an email (sent the sheet to someone before closing it the first time) it works but after closing excel and opening it later they are all broken.

I use 2007, dont use compatibility and run Windows7.

ANY HELP!!!!!!!! Thanks