how to permanetly disable macros on excel for mac 2011

Some users want to be able to edit data then abandon what theyve typed for a safely-saved version.

Probably with good intentions, Microsoft like so often did this exactly the wrong way: There is no option to disable it permanently.

The problem is that every time you open a file that is located in your OneDrive or SharePoint folder, it saves every change you do.

So what if you just want to look something up in an old file Or you want to use an old file, do some changes and save it under a new name.

AutoRecover How to disable AutoSave for one file only How to disable AutoSave permanently Change the registry manually Change the registry with a shortcut Download.

AutoRecover saves a copy of you file in a time period which you can define, e.g.

Unfortunately, especially for larger Excel files, it seems to not really work properly.

I even gained the impression that the AutoRecover function was the reason for Excel crashing.

The first time you use the AutoSave function you might also see a notification is shown on the image on the right-hand side.

In a nutshell right-click on the Quick Access Toolbar, then click on Customize Quick Access Toolbar, select AutoSave and click on Add.

If you need assistance with the Quick Access Toolbar please refer to this article.

However, you can achieve this by adding a value to the Windows registry.

One word of caution: Please be careful when editing the Windows registry.

Manually and automatically by downloading and opening a file.

ComputerHKEYCURRENTUSERSoftwareMicrosoftOffice16.0Excel Alternatively copy the path above and paste it into the address field.

Besides being an Excel enthusiast he loves photography and sports.

My boss howeverafter nearly an hour long lecture on the idiocy of a change I had absolutely no control over, I decided to see if someone had created a useful workaround.

But sometimes Id like them to keep a little bit the user in mind.

Is it possible that there is another setting that is overriding it.

If users havent learned to save as they go by now and need this nanny feature, they shouldnt be anywhere near a computer.

Because you will invariably find those decisions come from your own blinkered viewpoint.

If you come from the assumption that youd never want to lose any data you typed, it would make sense.

But this article describes the many, many scenarios when that assumption doesnt hold true.

This would baffle the designer of this feature, because they can only see their own point of view to the exclusion of all others.

How To Permanetly Disable Macros On Excel For Mac 2011