Hi Narendra,
i found the cause of your problem is links within the excel document. Clicking yes will open the file,but look at the data tab and check the edit links and connections. this is mainly caused by copy and paste information from one document to another. When it happens to me its caused all my charts to dissapear.