VBA Essbase Retrieve: Issues with big retrieves

Dear All,

I am having some issues with the some retrive I do using the VBA.

Basically I have a set of 10 excel templates on a remote server that need to be updated every month.

I did a macro that open each file, then retrieve the data with some input (basically the user choose the month) and then save the retrieved file on a specific folder.

It works fine, but sometimes and apparently without reasons, the version saved has not any "new" data, so it seems that it was not retrieve.

This is a piece of the macro:

For Each ret In RetrRange