LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 52
Default AutoFilter settings in shared workbook

I'm using a shared, protected workbook, with AutoFilter enabled, that allows
users to make edits in certain columns. When users edit the workbook and save
it, their AutoFilter settings are being saved as well, even when the Filter
settings box is unchecked in the Share Workbook dialog box. When another user
opens the workbook, the first user's AutoFilter settings are displayed.

Is there any way to prevent the AutoFilter settings from being saved along
with each user's edited changes?

Thanks!

--Jill
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
saving autofiltercustom filter settings Edwin199976 Excel Worksheet Functions 2 December 13th 06 06:52 PM
using autofilter in a shared protected workbook excel 2000? Needing Help for excel! Excel Discussion (Misc queries) 1 August 1st 06 06:24 PM
Shared workbook losing print settings koppers Excel Discussion (Misc queries) 0 November 11th 05 01:09 AM
How do I enable autofilter on a protected shared workbook? Bungle Excel Discussion (Misc queries) 3 August 9th 05 02:33 AM
Shared Workbook Settings, End User Update Changes Refresh Rate JESSENBE Excel Discussion (Misc queries) 0 July 19th 05 08:03 PM


All times are GMT +1. The time now is 11:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"