Any suggestions on identifying why Excel closes down when I added data to a
worksheet and refresh a pivot table that uses the data? It is about 1,000
rows of data so I prefer not to try to go row by row to find invalid data if
that is the culprit.

No error is displayed - it just shuts down. Is there error log somewhere I
can look at?

Thanks in advance!