I have a VBA program running in Excel 2016 for Mac EI-Capitan and Excel 2016 for Windows. Text color chart. The VBA program opens the excel file in network drive. - The network drive is located in US - The MAC EI-Capitan / Windows are located in US When the program run and calls code 'Application.Save()' in Excel 2016 for Mac, error 'Microsoft Excel isn't responding right now.

Do you want to wait or quit? When the program run and calls code 'Application.Save()', it is working fine. Can you please kindly advise if there is any parameter to improve the performance of 'Application.Save()' in Excel 2016 for Mac?

How to solve the error 'Microsoft Excel isn't responding right now.' Hi I try to make a search regarding similar issues but unfortunately no one face this issue before so there is no information. First of all I want to suggest you that try to run the same code on your local mac machine and test whether you can reproduce the issue or not. I think it will work correctly on your local machine.

So you need to find the p-value for your hypothesis test.To do so, employ the spreadsheet program Microsoft Excel.Using a simple formula, you can easily determine the p-value for your tests and thereby conclude strong or weak support of the null hypothesis. Probability values, or p-values, were popularized in the 1920s in statistics, though they've been around since the late-1700s.

So I guess it's because it is located in US. So the issue is in between these two locations when you try to run the code from your current location which is stored in US. I also want to suggest you to try to call the code using windows machine and check whether the same issue can be reproduce or not. I don't have your code and environment like yours so I am not able to reproduce the issue. You can also try to post the same issue on Answers Forum. Try to install latest updates on your mac machine and try to test the issue.

If still issue is there then you can try to submit your feedback to user voice. Excel Engineers will try to look in to the issue and if there is something wrong they will try to correct it. Regards Deepak MSDN Community Support Please remember to click 'Mark as Answer' the responses that resolved your issue, and to click 'Unmark as Answer' if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact. Hi if see your version, you are using 15.28 ( build 16111501).

Which was launched on Nov-15-2016. After that update, Microsoft launched 6 updates. Latest version is 15.32.0 (Build 17030901). Just launched before 15 days ago (March 14, 2017). Please try to update with latest version and try to test the issue.