Can I use solver functions in a protected (locked) worksheet?

Niels

Guest

Posts: n/a

16th Nov 2009

I am using the solver function to optimize a blend of products. I want to
lock (protect) some areas of the worksheet, but when doing so the solver
function will not work and the following translated message arrives:

The active document is not a worksheet, is protected or shared.

Hope someone can help me.

Thank you.

Niels

« conditional formatting | Workbook LOCKED - Up »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can I make a worksheet protected, locked AND not viewable?	MBozeman	Microsoft Excel Misc	2	13th Mar 2010 11:31 PM
Can I use solver function in a locked (protected) worksheet	Niels	Microsoft Excel Crashes	1	27th Nov 2009 08:39 AM
Using solver function in a locked (protected) worksheet	Niels	Microsoft Excel Worksheet Functions	2	16th Nov 2009 09:55 PM
How use group and ungroup functions while worksheet is protected	=?Utf-8?B?R2FicmllbCBEZSBsYSBHYXJ6YQ==?=	Microsoft Excel Worksheet Functions	1	17th Nov 2004 01:44 AM
Making functions available in a protected worksheet	sdrane	Microsoft Excel Misc	0	21st Feb 2004 08:13 PM