Excel crashes when trying to update a data source in a pivot table

Hmm this happens to me as well, when i update the source with a macro. it only works when i open the source file first. But i dont know why