software

I am working in Excel 2000, with a protected worksheet emailed to me from
another co-worker. After unprotecting the worksheet (and workbook), I am
still unable to revise a formula. When I make the revision and press enter
(or the green checkmark) the formula does not change, but instead appears in
the cell that the calculation formerly appeared in. How do I make the
revision to the formula?


what happens when you press Ctrl and ` thats the key beside the 1 key--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=519944Nothing.

quot;davesexcelquot; wrote:

gt;
gt; what happens when you press Ctrl and ` thats the key beside the 1 key
gt;
gt;
gt; --
gt; davesexcel
gt; ------------------------------------------------------------------------
gt; davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
gt; View this thread: www.excelforum.com/showthread...hreadid=519944
gt;
gt;


try going to tools, options,calculation, be sure calculation are set to
automatic--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=519944Change cell format to general, it might be text, you might have to go into
editing mode first (first change format, then press F2 then enter)

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;Jennifer Hquot; gt; wrote in message
...
gt;I am working in Excel 2000, with a protected worksheet emailed to me from
gt; another co-worker. After unprotecting the worksheet (and workbook), I am
gt; still unable to revise a formula. When I make the revision and press
gt; enter
gt; (or the green checkmark) the formula does not change, but instead appears
gt; in
gt; the cell that the calculation formerly appeared in. How do I make the
gt; revision to the formula?Tried that yesterday, didn't do anything. Thanks for your help, though! Any
other ideas?

quot;davesexcelquot; wrote:

gt;
gt; try going to tools, options,calculation, be sure calculation are set to
gt; automatic
gt;
gt;
gt; --
gt; davesexcel
gt; ------------------------------------------------------------------------
gt; davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
gt; View this thread: www.excelforum.com/showthread...hreadid=519944
gt;
gt;

Hi Jennifer,
Did you receive the file as an .xls file or with a different extension.

Can you enter the formula in another column and have it work there
Check the format of the cell with the formula
select cell, format, cells, then is it General or at least something other than Text

Try each of the things already suggested again that you already tried, because I don't think they
will flag the file as needing to be saved.
Tools, Options, Calculation, automatic
Tools, options, View, uncheck Formulas (for viewing formulas)
select the column, Format, cells, General

Change the formula on the formula bar after hitting F2, make sure there
are no spaces to left or right of formula then hit Enter.
If that fixes it then you might fix entire columns using the TrimALL macro
www.mvps.org/dmcritchie/excel/join.htm#trimall

Check the title bar for the word [shared] if you see that, then see
www.mvps.org/dmcritchie/excel/hilight.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;Jennifer Hquot; gt; wrote in message news
gt; Tried that yesterday, didn't do anything. Thanks for your help, though! Any
gt; other ideas?
gt;