Actually the problem I found out was that it was not updating the charts after opening the file through the script as it normally do when you open the file by double clicking. So, I write down a macro to update the charts and then called that macro in the script and the problem is solved now.