Rapp Scallion
New Member
- Joined
- Mar 14, 2002
- Messages
- 2
At my job one of our employees has published an Excel worksheet on our intranet where it can be viewed as an embedded object within Internet Explorer. The sheet is a simple enough affair: some data, some hyperlinks that lead to various cells within the same worksheet and an autofilter to sort the data. The problem is that whenever someone uses the autofilter-function Excel (or IE) will regard that as a change to the worksheet and the next time the user clicks a hyperlink she or he is prompted about saving the file. As you might imagine that gets very annoying very quickly. I've tried protecting the worksheet but that disable the functionality of the Autofilter tabs, which is not an option. Is there some way of stopping Excel from tracking changes to the worksheet so it will stop pestering users about saving "unsaved" changes?