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.

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.