Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Stopping Excel from tracking "changes"

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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?

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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?

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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?

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •