Excel宏 [英] Excel macros

问题描述

我有一个没有宏的xl文件可以用于Solver程序。我估计大约一年前它对我有用。现在，我正在重新审视数据，每当我要求Solver解决时，程序告诉我Solver无法找到可行的解决方案。
所以，我打开了另一个文件（从前面解决了）并点击了解决按钮，仍然得到了相同的答案。有人可以帮我弄清楚发生了什么吗？

谢谢。

Sowmya

解决方案

嗨Sowmya，



您是否在Excel中添加了Solver加载项？



[档案]> [选项] 



问候，

I got an xl file without macros to use with the Solver program. I reckon that it worked for me about a year back. Now, that I am revisiting the data, every time I ask the Solver to solve, the program tells me that Solver cannot find a feasible solution. So, I opened another file (solved from earlier) and hit the solve button, and still got the same answer. Can someone help me figure out what is going on ?

Thank you.

Sowmya

解决方案

Hi Sowmya,

Have you added Solver add-in in your Excel?

[File] > [Options] 

Regards,

这篇关于Excel宏的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！