Possible corrupted file -Excel scan to fix

[thedeadzeds]

Hi Guys,

I have a file and i think its become corrupted. If you click in the formula bar although the formulas seems to be ok, the text is all in different fonts and colours. Any thoughts? Is there a way to run a scan on a excel file to try and clean up any errors.

Thanks

 

[Logit]

.
This freebie has worked numerous times here (but not all the time, depends on the issues):

https://excelfilecleaner.codeplex.com/releases/view/85025


In the VBE try: TOOLS / CLEAN PROJECT and also DEBUG / COMPILE VBA PROJECT

 

[RoryA]

Do you mean that one cell has multiple fonts/colours in the formula bar when selected, or that different cells show different colours / fonts?