Disable autosave for your very large PowerPivot workbook to gain performance

When working with very large PowerPivot files the Excel autosave will make your PowerPivot very slow on moments it does its autosave. You can disable it for this single workbook (remember to save it yourself from time to time!)

Go to File ->Options.

Click on Save and uncheck “Disable Autorecover for this workbook only”.

This one is ofcourse on your own risk 🙂 but it saved me a lot of annoyance every 10 minutes.

2 Replies to “Disable autosave for your very large PowerPivot workbook to gain performance

  1. Hey Kasper,

    Didn’t you mean CHECK instead of uncheck in the following sentence?

    Click on Save and uncheck “Disable Autorecover for this workbook only”.

    Nevertheless, interesting tip!

    Regards,
    Valentino.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.