Compatability check..

[yuppicide]

I get XLS files on a regular basis from our suppliers. I sort the by 4
different conditions, which the old Excel only allowed 3.

When saving I always get the "minor loss of fidelity" message that
information will be lost in earlier versions of Excel.

I have to uncheck "Check compatability when saving this workbook" and hit
continue.

Is there a way to turn that off?

 

[Jeff Strickland]

I get XLS files on a regular basis from our suppliers. I sort the by 4
different conditions, which the old Excel only allowed 3.

When saving I always get the "minor loss of fidelity" message that
information will be lost in earlier versions of Excel.

I have to uncheck "Check compatability when saving this workbook" and hit
continue.

Is there a way to turn that off?

Which version of Office?

 

[yuppicide]

Sorry.. it was Office 2007, but I found an add-in to do it for me.