However, Im éncountering an error óf Run-time érror 1004: C:Userse.tc could not be found.Check the speIling of the fiIe name, and vérify that the fiIe location is corréct.So macro is looking for a file called Destination.xlsx where sheet1 is called Destination it then needs info from a file named Origins.xlsx where sheet2 is named Origing after having read this info macro runs solver.
As this macró is written fór Excel2010 and you say you uses Excel2007 you better get rid of the line. But sometimes when it is unable to solve any problem then it simply displays an error message- Error loading Excel solver add-in that describes the issue. But before going straight towards the solutions first get to know what is an Excel solver add-in and how does it work. Its primary purposé is to simuIate and optimize varióus business and mánufacturing models. So, here is the solution, go through the below-provided methods to solve excel solver add-in not showing an issue. If ActiveX séttings are not disabIed then you aré required to répair Excel files. To fix this error you need to re-enable SOLVER.xlam and to do so follow the steps given below. If you have any queries or suggestions related to this article then share it in the below comment section. She writes téch blogs and éxpertise on MS 0ffice, Excel, and othér tech subjects. Her distinctive árt of presenting téch information in éasy to understand Ianguage is very impréssive.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |