This is because your file is .twbx that's reading data from the local folder.
Here is an example.
Actual twbx file connected to excel:
I saved it and closed the file. Then I updated the data source.
I again opened the twbx file but values did not change.
And the solution is to edit your connection:
Specify path of the file and you should get the updated values.
If this helps, please mark the answer as correct and helpful.