Question

excel display the error ___ when cell refrence is not valid ​

Answer 1

Answer:

This is one of the main reasons of "Data source is not valid" Error. Even if you change the name of the data source, it can cause the error. You need to change the name in Excel connections too. To solve this error, go to Data --> Get External Data --> Existing Connection.

Explanation:

HOPE IT HELPS

PLEASE FOLLOW ME