It’s doubtful that Excel will automatically sense and update a pivot table if you add new cells outside of the current table’s range. That’s a weakness that Sheets has, too.