Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 how to set solver options as available in Excel 2003
I'm trying to set solver options in Excel 2007 but cannot find the options
menu that is available in Exccel 2003 that is showing tangential estimates, search etc. Surely Microsoft have not become Luddites and destroyed what they once had? As a general gripe, just to vent my steam, why is the Microsoft Help system so basically useles so often Sure I may not be searching optimally. But I'm not stupid and I would have thought any decent search system responding to "set solver options" would give me the answer I am looking for, and not 100 useless items to do with printing etc. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 how to set solver options as available in Excel 2003
look in the datatab. and look under what if.
Might be what your looking for Anthony "HenryAlive" wrote in message ... I'm trying to set solver options in Excel 2007 but cannot find the options menu that is available in Exccel 2003 that is showing tangential estimates, search etc. Surely Microsoft have not become Luddites and destroyed what they once had? As a general gripe, just to vent my steam, why is the Microsoft Help system so basically useles so often Sure I may not be searching optimally. But I'm not stupid and I would have thought any decent search system responding to "set solver options" would give me the answer I am looking for, and not 100 useless items to do with printing etc. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 how to set solver options as available in Excel 2003
If I search "set solver options" the 6th topic is "Solver Options", which
gives copious information about the options. If I search simply "solver" the 1st topic is "Define and solve a problem by using Solver". This starts off by explaining how to install the addin (if not already) then where to find it (Data, Analysis) and use it. If your help does not give similar I suspect you have not installed the April-09 update for Excel's Help, see KB963678, (it's a significant improvement). Regards, Peter T "HenryAlive" wrote in message ... I'm trying to set solver options in Excel 2007 but cannot find the options menu that is available in Exccel 2003 that is showing tangential estimates, search etc. Surely Microsoft have not become Luddites and destroyed what they once had? As a general gripe, just to vent my steam, why is the Microsoft Help system so basically useles so often Sure I may not be searching optimally. But I'm not stupid and I would have thought any decent search system responding to "set solver options" would give me the answer I am looking for, and not 100 useless items to do with printing etc. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003/2007 print chart options | Charts and Charting in Excel | |||
referencing Solver.xlam vs. Solver.xla - 2007 vs. 2003 | Excel Programming | |||
Excel 2007 unrecognized file format in Excel 2003 More options | Excel Discussion (Misc queries) | |||
how do you use solver in excel 2003 | Excel Discussion (Misc queries) | |||
Solver and Excel 2003 | Excel Programming |