Hi,
I have an Excel 2010 workbook that is used by a team of people. I am finding that people keep filtering the data and then using the copy/drag funciton (where you grab the handle of the cell and drag down). This keeps knocking out the conditional formatting. I would like to disable this feature but only for that workbook. Disabling it via OPTIONS > ADVANCED seems to change the default for all workbooks for a single user. Does anyone konw if it's possible to limit it to just the workbook and have the funcation disabled for anyone that opens the spreadsheet? I can't do it via sheet protection as the users do need to change the entries in the cells.
Thanks in advance.
Bookmarks