Microsoft Office Questions? Ask a IT Expert for Support ASAP
Hi, welcome and thank you for your question. My name is ***** ***** I am glad to assist you today.
I am very sorry about your issues. If the file is XLSM, then it contains macro. I suggest that you upload the file here in the link below, then give me the short download link.
Please let me know by replying to me here so that I can help you further.
I got the sample file and Excel froze due to a lot of missing files being referenced in the formulas. I believe this is not an issue from your part since those files being referenced in the formulas are accessible by your Excel? The files are in a Z drive. Please confirm
No, the referencing are still there so I believe that is the reason why Excel froze.
Do you want me to turn off the referencing of the external files?
Here is the file with references of external files removed:
Unfortunately, that is not possible since I do not provide phone support. Just send him the file and see if it still works from his end with references removed.
Just let me know whatever is his comments on the revised file so that I can assist you further.
Yes, no problem. Please take your time and we can resume with this tomorrow then. Just let me know when you are back and available so that we can resume.
You're welcome Dan. Till tomorrow then.
Thank you for writing back and I am sorry for the late reply. I am from a different time zone and it is 7:06AM now by the time of this writing.
I believe the problem is with his Excel 2016. Please ask him to TURN OFF or DISABLE all plugins first, then try to open the said file. To disable the plugins, click on File => Excel Options. Click on Addins and then click on GO button. Uncheck all items there to disable.
Please keep me posted with your results so that I can assist you further.
Ok please take your time
Thank you for writing back. Yes, please take your time. You can surely come back to me here in this chat thread any time should you need further assistance and after the planned upgrade of your machine.
I hope I was able help.Please remember to rate my service positively (3-5 stars/faces) if this helped. Tips are always highly appreciated!
If you need further assistance, please do not rate me negatively with 1 or 2 faces. Instead, please reply to me so that I can help you further. You can surely get back to me here any time even after your rating.