Forum Discussion

Phar's avatar
Phar
Frequent Visitor
8 years ago

How do I lock down my pivot table so it doesn't refresh?

I am trying to preserve historical reports so that I can look back at last month's reports without them refreshing.  I don't know how to lock down the tables so they can't be refreshed.   Is there...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hey Phar

 

In the query editor, you can right click on the table on the left side and unselect "Include in report refresh." Make sure the checkbox is not showing.

 

 

Hope this helps,

Parker

Phar's avatar
Phar
Frequent Visitor
8 years ago

Thanks Parker, but I can't find the option to unselect "Include in report refresh."  


  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Phar

     

    See edited post above.

     

    -Parker

  • Phar's avatar
    Phar
    Frequent Visitor
    8 years ago

    This is my drop down selection.  



    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Phar

       

      What datasource are you using and how are you connecting to it (Import or DirectQuery)?

      • Phar's avatar
        Phar
        Frequent Visitor
        8 years ago

        Anonymous
        I'm not sure I understand.  I download and overwrite reports (excel tables) from a web interface nightly.  So, I'm guessing I
        import.

        Yes, I am a newbie.
        Thanks.