is there a limit to the number of columns a pivot table will count from? i didn't add or change the colums the data table the pivot was pulling from but when i 'refreshed' the data the prior 28 columns of data vanished. any ideas how to adjust this? i've tried to use a different calculation (sum, count) and data populates. what gives?