Stopping Excel from tracking "changes"

Rapp Scallion · Mar 15th, 2002, 08:26 AM

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?

Mark W. · Mar 15th, 2002, 12:01 PM

Perhaps I don't fully understand your situation, but have you unchecked the "Track changes when editing..." check box found by using the Tools | Track Changes | Highlight Changes... menu command?

Rapp Scallion · Mar 18th, 2002, 12:42 AM

I'm afraid you misunderstand me, perhaps my description of the problem wasn't sufficient. I'm afraid English is not my native language.

What I mean with "changes" is when the workbook is altered in such a way that Excel asks if you want to save it. Imagine creating a new workbook and entering some simple data and then clicking the Close button. Excel will prompt you if you want to save the changes to the workbook.

My problem is that whenever someone uses the Autoformat funktion Excel will regard that as a change to the workbook and when the user clicks a hyperlink within the same document he/she will be prompted to save the document. Very annoying. I can protect the document but that will also turn off the Autofilter function (which must remain active).

My questions in short: Is there a way to stop Excel from prompting the user about saving the document when he/she uses the document from within Internet Explorer?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 15th, 2002, 08:26 AM	#1
Rapp Scallion New Member Join Date: Mar 2002 Posts: 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?

Mar 15th, 2002, 12:01 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Perhaps I don't fully understand your situation, but have you unchecked the "Track changes when editing..." check box found by using the Tools \| Track Changes \| Highlight Changes... menu command?

Mar 18th, 2002, 12:42 AM	#3
Rapp Scallion New Member Join Date: Mar 2002 Posts: 2	I'm afraid you misunderstand me, perhaps my description of the problem wasn't sufficient. I'm afraid English is not my native language. What I mean with "changes" is when the workbook is altered in such a way that Excel asks if you want to save it. Imagine creating a new workbook and entering some simple data and then clicking the Close button. Excel will prompt you if you want to save the changes to the workbook. My problem is that whenever someone uses the Autoformat funktion Excel will regard that as a change to the workbook and when the user clicks a hyperlink within the same document he/she will be prompted to save the document. Very annoying. I can protect the document but that will also turn off the Autofilter function (which must remain active). My questions in short: Is there a way to stop Excel from prompting the user about saving the document when he/she uses the document from within Internet Explorer?