Excel pivot table data source not valid

The perspective is needed because the work requires it, and it turns out that no matter how you create it, it always says “data source invalid”
Checked Baidu experience, after saying is two reasons: 1. Title bar has space 2. Title bar may be merged cells
But it is of no damn use
In the deletion of no sequence is still invalid after finally found the reason, the original is the reason for the file name, the file name can not have [], tragedy, thank you here this netizen, in order to forget, or write an article to commemorate it
The original link:
https://zhidao.baidu.com/question/367555675.html
 


Read More: