Our organization is partway through an upgrade from Office97 to OfficeXP. We
have a lot of Excel files with macros, and on some PCs, there is an issue
with it "failing to compile" and having errors (hard for me to test, because
I'm in a different location and I'm one of the lucky ones with a PC that
works).

Troubleshooting over the phone, it appears the issue is under (VBA)
tools/references had Microsoft Office 8.0 checked, and it is now missing. I
had a user uncheck that, and instead check the Microsoft Office 9.0 (I'm not
sure why, mine says 10.0 but hers says 9.0). The file ran (woot!) but she
then called back and said that it "didnt save the setting" when she went to
run it again.

I don't know enough to know what is going on- is this setting in the file
itself, in which case we have hundreds (literally) of files that need to be
changed, or is it something that should only have to be changed once, but
maybe our "locked down" applications aren't allowing the setting to take on
her computer? If anyone can give any insight as to whether those reference
settings are file-specific vs global to excel, would be greatly appreciated!

Thanks,
Keith