I have a pivot table that includes about 700 rows of data. They contain names of employees and hours worked by category. I added a row about midway down the source data with a new employee name and refreshed the pivot. I confirmed that the pivot was still referencing the entire data which it is. The pivot picks up the new employee name, so I know it sees the row, but it will not pick up the data in the other columns. The table remains blank for that new employee. I changed the name to an existing employee and it still doesn't pick up the data. I even reset the pivot table datasource and nada !

Any clues?

Thanks in advance