Okay, I think I've figured out why we're getting such different results. I've been trying it with the .xls file. I gave it a try on the .xlsx file, and your steps worked. However, the version we use needs to stay as a .xls, for legacy compatibility reasons(and I can't convert>fix>convert back due to annoying issues related to embedded macros), so a .xlsx-only fix doesn't help me.
|