In looking at your question, and the process you are running through it looks like the workbook at times is going to hit a cache. What you could try is is appending refresh=y at the end of your URL. If this shows the new information you'll know whether it's the cache or not.
If it is the cache, you could use the below article (dependent on your requirements - just remember cache is used to speed up workbooks that are opened often)
The above article helps to set the cache value.
Hopefully the above helps