no need to format or anything else
you have xp or win7 either office2003 or
office2007 or whatever it is
just install "
msxml 6.0 service pack1 "
for all type of compile errors In ITR excel
you can download this utility from the link below
(32bit Operating Systems) or (64bit OS but if you installed MS Office 32bit )
you can Download Microsoft Core XML Services (MSXML) 6.0 Service Pack 1 32 bit from Here
( 64bit Operating Systems and having MS Office 64bit )
you can Download Microsoft Core XML Services (MSXML) 6.0 Service Pack1 64bit from Here