why everytime I open excel 2007 it always in compatibility mode?
R Ron de Bruin Aug 24, 2007 #2 Hi Jus Set your format to one of the new 2007 formats Office Buttton >Excel options..Save
J Jus Sep 2, 2007 #3 Hi Ron, Big thanks, yup i save the book1 to new excel format and it solved the problem.