If you're using Excel 97 make sure both service releases 1, 2 are installed.
Free installers from Microsoft: