software

I need help. If i turn on or turn off Autofilter, Excel autosaving workbook.
I can not find solution. This problem in all files.

This is not usual behavior.

I would suspect some sort of addin that's helping out if this really happens in
all the workbooks. (If it only happens in a few--not all), then it may not be
an addin. It could be a developer that's helping out.)

If it's just a few workbooks, I'd talk to the developer to see what was going
on.

If it happens in all workbooks, then...

Chip Pearson has some notes on how to diagnose startup errors at:
www.cpearson.com/excel/StartupErrors.htm

And Jan Karel Pieterse has more notes at:
www.jkp-ads.com/Articles/StartupProblems.htm

Jaan wrote:
gt;
gt; I need help. If i turn on or turn off Autofilter, Excel autosaving workbook.
gt; I can not find solution. This problem in all files.

--

Dave Peterson

Thanks Dave
This problem I have with my work compyter. I had sent one file to my home
computer and now there J have that same problem. Is it possible,if same macro
running on the background.

quot;Dave Petersonquot; kirjutas:

gt; This is not usual behavior.
gt;
gt; I would suspect some sort of addin that's helping out if this really happens in
gt; all the workbooks. (If it only happens in a few--not all), then it may not be
gt; an addin. It could be a developer that's helping out.)
gt;
gt; If it's just a few workbooks, I'd talk to the developer to see what was going
gt; on.
gt;
gt; If it happens in all workbooks, then...
gt;
gt; Chip Pearson has some notes on how to diagnose startup errors at:
gt; www.cpearson.com/excel/StartupErrors.htm
gt;
gt; And Jan Karel Pieterse has more notes at:
gt; www.jkp-ads.com/Articles/StartupProblems.htm
gt;
gt; Jaan wrote:
gt; gt;
gt; gt; I need help. If i turn on or turn off Autofilter, Excel autosaving workbook.
gt; gt; I can not find solution. This problem in all files.
gt;
gt; --
gt;
gt; Dave Peterson
gt;

Macros live in workbooks. So if the macro is in that workbook, then yep, that
could be a problem.

But one of the suggestions in both Chip's and Jan Karel's notes is to disable
macros, then open the workbook.

That way you can see if it is a macro.

close excel
windows start button|run
excel /safe

file|open yourworkbook.xls

Test it out.

If it worked ok, then it could have been a macro.

Make sure you read Chip's and Jan Karel's notes for a better explanation.

Jaan wrote:
gt;
gt; Thanks Dave
gt; This problem I have with my work compyter. I had sent one file to my home
gt; computer and now there J have that same problem. Is it possible,if same macro
gt; running on the background.
gt;
gt; quot;Dave Petersonquot; kirjutas:
gt;
gt; gt; This is not usual behavior.
gt; gt;
gt; gt; I would suspect some sort of addin that's helping out if this really happens in
gt; gt; all the workbooks. (If it only happens in a few--not all), then it may not be
gt; gt; an addin. It could be a developer that's helping out.)
gt; gt;
gt; gt; If it's just a few workbooks, I'd talk to the developer to see what was going
gt; gt; on.
gt; gt;
gt; gt; If it happens in all workbooks, then...
gt; gt;
gt; gt; Chip Pearson has some notes on how to diagnose startup errors at:
gt; gt; www.cpearson.com/excel/StartupErrors.htm
gt; gt;
gt; gt; And Jan Karel Pieterse has more notes at:
gt; gt; www.jkp-ads.com/Articles/StartupProblems.htm
gt; gt;
gt; gt; Jaan wrote:
gt; gt; gt;
gt; gt; gt; I need help. If i turn on or turn off Autofilter, Excel autosaving workbook.
gt; gt; gt; I can not find solution. This problem in all files.
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson

Hi Dave

I´m sorry. I´m very stupid. I dont look correctly. If I turn on or off
Autofilter, Excel not saving, but deactivating Undo and Redo(Can´t Undo). I
had open Excel in Safe Mode, but same problem. I had try open empty file, but
same problem.I had disable macros, but that same. I hope, you undestand, what
I mean

Jaan

quot;Dave Petersonquot; kirjutas:

gt; Macros live in workbooks. So if the macro is in that workbook, then yep, that
gt; could be a problem.
gt;
gt; But one of the suggestions in both Chip's and Jan Karel's notes is to disable
gt; macros, then open the workbook.
gt;
gt; That way you can see if it is a macro.
gt;
gt; close excel
gt; windows start button|run
gt; excel /safe
gt;
gt; file|open yourworkbook.xls
gt;
gt; Test it out.
gt;
gt; If it worked ok, then it could have been a macro.
gt;
gt; Make sure you read Chip's and Jan Karel's notes for a better explanation.
gt;
gt; Jaan wrote:
gt; gt;
gt; gt; Thanks Dave
gt; gt; This problem I have with my work compyter. I had sent one file to my home
gt; gt; computer and now there J have that same problem. Is it possible,if same macro
gt; gt; running on the background.
gt; gt;
gt; gt; quot;Dave Petersonquot; kirjutas:
gt; gt;
gt; gt; gt; This is not usual behavior.
gt; gt; gt;
gt; gt; gt; I would suspect some sort of addin that's helping out if this really happens in
gt; gt; gt; all the workbooks. (If it only happens in a few--not all), then it may not be
gt; gt; gt; an addin. It could be a developer that's helping out.)
gt; gt; gt;
gt; gt; gt; If it's just a few workbooks, I'd talk to the developer to see what was going
gt; gt; gt; on.
gt; gt; gt;
gt; gt; gt; If it happens in all workbooks, then...
gt; gt; gt;
gt; gt; gt; Chip Pearson has some notes on how to diagnose startup errors at:
gt; gt; gt; www.cpearson.com/excel/StartupErrors.htm
gt; gt; gt;
gt; gt; gt; And Jan Karel Pieterse has more notes at:
gt; gt; gt; www.jkp-ads.com/Articles/StartupProblems.htm
gt; gt; gt;
gt; gt; gt; Jaan wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; I need help. If i turn on or turn off Autofilter, Excel autosaving workbook.
gt; gt; gt; gt; I can not find solution. This problem in all files.
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt;
gt; gt; gt; Dave Peterson
gt; gt; gt;
gt;
gt; --
gt;
gt; Dave Peterson
gt;

There's lots of things that kill the Edit|Undo stack.

I don't know a way of changing excel's behavior. It's just one of those things
we have to live with.

Jaan wrote:
gt;
gt; Hi Dave
gt;
gt; I´m sorry. I´m very stupid. I dont look correctly. If I turn on or off
gt; Autofilter, Excel not saving, but deactivating Undo and Redo(Can´t Undo). I
gt; had open Excel in Safe Mode, but same problem. I had try open empty file, but
gt; same problem.I had disable macros, but that same. I hope, you undestand, what
gt; I mean
gt;
gt; Jaan
gt;
gt; quot;Dave Petersonquot; kirjutas:
gt;
gt; gt; Macros live in workbooks. So if the macro is in that workbook, then yep, that
gt; gt; could be a problem.
gt; gt;
gt; gt; But one of the suggestions in both Chip's and Jan Karel's notes is to disable
gt; gt; macros, then open the workbook.
gt; gt;
gt; gt; That way you can see if it is a macro.
gt; gt;
gt; gt; close excel
gt; gt; windows start button|run
gt; gt; excel /safe
gt; gt;
gt; gt; file|open yourworkbook.xls
gt; gt;
gt; gt; Test it out.
gt; gt;
gt; gt; If it worked ok, then it could have been a macro.
gt; gt;
gt; gt; Make sure you read Chip's and Jan Karel's notes for a better explanation.
gt; gt;
gt; gt; Jaan wrote:
gt; gt; gt;
gt; gt; gt; Thanks Dave
gt; gt; gt; This problem I have with my work compyter. I had sent one file to my home
gt; gt; gt; computer and now there J have that same problem. Is it possible,if same macro
gt; gt; gt; running on the background.
gt; gt; gt;
gt; gt; gt; quot;Dave Petersonquot; kirjutas:
gt; gt; gt;
gt; gt; gt; gt; This is not usual behavior.
gt; gt; gt; gt;
gt; gt; gt; gt; I would suspect some sort of addin that's helping out if this really happens in
gt; gt; gt; gt; all the workbooks. (If it only happens in a few--not all), then it may not be
gt; gt; gt; gt; an addin. It could be a developer that's helping out.)
gt; gt; gt; gt;
gt; gt; gt; gt; If it's just a few workbooks, I'd talk to the developer to see what was going
gt; gt; gt; gt; on.
gt; gt; gt; gt;
gt; gt; gt; gt; If it happens in all workbooks, then...
gt; gt; gt; gt;
gt; gt; gt; gt; Chip Pearson has some notes on how to diagnose startup errors at:
gt; gt; gt; gt; www.cpearson.com/excel/StartupErrors.htm
gt; gt; gt; gt;
gt; gt; gt; gt; And Jan Karel Pieterse has more notes at:
gt; gt; gt; gt; www.jkp-ads.com/Articles/StartupProblems.htm
gt; gt; gt; gt;
gt; gt; gt; gt; Jaan wrote:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; I need help. If i turn on or turn off Autofilter, Excel autosaving workbook.
gt; gt; gt; gt; gt; I can not find solution. This problem in all files.
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt;
gt; gt; gt; gt; Dave Peterson
gt; gt; gt; gt;
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson

As I undestand,this is Excel problem, not my.Thanks

quot;Dave Petersonquot; kirjutas:

gt; There's lots of things that kill the Edit|Undo stack.
gt;
gt; I don't know a way of changing excel's behavior. It's just one of those things
gt; we have to live with.
gt;
gt; Jaan wrote:
gt; gt;
gt; gt; Hi Dave
gt; gt;
gt; gt; I´m sorry. I´m very stupid. I dont look correctly. If I turn on or off
gt; gt; Autofilter, Excel not saving, but deactivating Undo and Redo(Can´t Undo). I
gt; gt; had open Excel in Safe Mode, but same problem. I had try open empty file, but
gt; gt; same problem.I had disable macros, but that same. I hope, you undestand, what
gt; gt; I mean
gt; gt;
gt; gt; Jaan
gt; gt;
gt; gt; quot;Dave Petersonquot; kirjutas:
gt; gt;
gt; gt; gt; Macros live in workbooks. So if the macro is in that workbook, then yep, that
gt; gt; gt; could be a problem.
gt; gt; gt;
gt; gt; gt; But one of the suggestions in both Chip's and Jan Karel's notes is to disable
gt; gt; gt; macros, then open the workbook.
gt; gt; gt;
gt; gt; gt; That way you can see if it is a macro.
gt; gt; gt;
gt; gt; gt; close excel
gt; gt; gt; windows start button|run
gt; gt; gt; excel /safe
gt; gt; gt;
gt; gt; gt; file|open yourworkbook.xls
gt; gt; gt;
gt; gt; gt; Test it out.
gt; gt; gt;
gt; gt; gt; If it worked ok, then it could have been a macro.
gt; gt; gt;
gt; gt; gt; Make sure you read Chip's and Jan Karel's notes for a better explanation.
gt; gt; gt;
gt; gt; gt; Jaan wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; Thanks Dave
gt; gt; gt; gt; This problem I have with my work compyter. I had sent one file to my home
gt; gt; gt; gt; computer and now there J have that same problem. Is it possible,if same macro
gt; gt; gt; gt; running on the background.
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Dave Petersonquot; kirjutas:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; This is not usual behavior.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; I would suspect some sort of addin that's helping out if this really happens in
gt; gt; gt; gt; gt; all the workbooks. (If it only happens in a few--not all), then it may not be
gt; gt; gt; gt; gt; an addin. It could be a developer that's helping out.)
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; If it's just a few workbooks, I'd talk to the developer to see what was going
gt; gt; gt; gt; gt; on.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; If it happens in all workbooks, then...
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Chip Pearson has some notes on how to diagnose startup errors at:
gt; gt; gt; gt; gt; www.cpearson.com/excel/StartupErrors.htm
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; And Jan Karel Pieterse has more notes at:
gt; gt; gt; gt; gt; www.jkp-ads.com/Articles/StartupProblems.htm
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Jaan wrote:
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; I need help. If i turn on or turn off Autofilter, Excel autosaving workbook.
gt; gt; gt; gt; gt; gt; I can not find solution. This problem in all files.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; --
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Dave Peterson
gt; gt; gt; gt; gt;
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt;
gt; gt; gt; Dave Peterson
gt; gt; gt;
gt;
gt; --
gt;
gt; Dave Peterson
gt;