Attach Setting to Document, Not Excel Program on Computer

kimptheta

New Member
Joined
Aug 28, 2014
Messages
1
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
 

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Watch MrExcel Video

Forum statistics

Threads
1,127,742
Messages
5,626,618
Members
416,195
Latest member
tonmcg

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top