title: Can I use solver on pivot tables?
body: <p>I am trying to use solver on a pivot table. Is this possible? I am trying to change the sum to 60000. So in solver I set the value to 60000. But run into an issue of "objective cell contents must be a formula. So then I enter in a cell below the grand total = b35(or whatever the grand total cell is) And then I run into the issue of solver running into an error etc..</p>
  
  <p>Any tips?</p>