Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why is Excel's "solver" not always available on new worksheets?
Hi,
I'm having some trouble accessing the Excel "solver" tool on new worksheets I create within a default .xls file. Are there possible memory limits on a file size that prevent "solver" from running? Is "solver" on the Office XP version explicitly limited to 4 or less sheets? It's a shame I have to let this spreadsheet die than continue. Can anyone suggest a way to make "solver" accessible from any worksheet within my Excel file? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why is Excel's "solver" not always available on new worksheets?
Solver is not tied to a worksheet. It is globally available (or
unavailable) within XL. What do you want to do with a new worksheet and Solver? How are you trying to get it done? How does it not work? -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... Hi, I'm having some trouble accessing the Excel "solver" tool on new worksheets I create within a default .xls file. Are there possible memory limits on a file size that prevent "solver" from running? Is "solver" on the Office XP version explicitly limited to 4 or less sheets? It's a shame I have to let this spreadsheet die than continue. Can anyone suggest a way to make "solver" accessible from any worksheet within my Excel file? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Worksheets from one Workbook to Another | Excel Worksheet Functions | |||
Adding same cells across multiple worksheets | Excel Worksheet Functions | |||
Changing a Link Mid-way Across Worksheets | Excel Worksheet Functions | |||
Define list of worksheets | Excel Worksheet Functions | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) |