Follow the steps given here to Fix <a href="https://www.mygeekshelp.com/how-to-fix-run-time-error-1004-in-excel/">Run time error 1004 while opening excel</a>, this blog will help you guide and troubleshoot the problem.