title: Why do my pivot tables sometimes lose their bottom border?
body: <p>In Excel I've made a number of pivot tables in order to display text information for users (I've had to block out a lot of the information in the image below!)</p>
  
  <p>I have a macro that changes the filter to a certain user for all of these, however, for each different user, at least one of these pivot tables seems to lose the styling for the bottom border and the only correlation I can find is when there are two rows in the pivot table. The example below shows that two of them at the bottom have no bottom border, however, when you change the filter to another user this could be one or more different tables. There is no hidden cell below these, they all use the same pivot style and all have "preserve cell formatting on update" selected.</p>
  
  <p>Why is this only happening when there are two rows in the pivot table?</p>
  
  <p><img src="https://s32.postimg.org/nsm49dbk5/Capture.jpg" alt="Pivottables"></p>