Attach Setting to Document, Not Excel Program on Computer

[kimptheta]

Hi all,

Sorry if this is already out there and I missed it (in which case, please feel free to share the useful link ), but I was wondering if there was anyway to tie settings to a shared document. The details are as follows:

I have an excel shared on a server with many other people. To help prevent accidental overwriting of important, unique information, I want to turn off auto fill and auto complete. I was able to do this on my computer's excel program, via file-options-advanced. However, this setting does not stay with this particular excel workbook on other computers (i.e., if someone opens this workbook on a different computer, auto fill and and auto complete are not turned off). Additionally, I don't want to completely turn off auto fill and auto complete on their computer excel programs because they will also be working on other excel workbook files for which such tools would be helpful. So, any suggestions on means to tie a turned off auto fill and auto complete to the particular file, and not the whole excel program?

Any advice, tips, or references to other helpful places to look would be greatly, greatly appreciated! Thanks in advance for the help!!

Thanks very much,

Kim