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: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=519944

Nothing.

"davesexcel" wrote:


what happens when you press Ctrl and ` thats the key beside the 1 key


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=519944

try going to tools, options,calculation, be sure calculation are set to
automatic


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=519944

Tried that yesterday, didn't do anything. Thanks for your help, though! Any
other ideas?

"davesexcel" wrote:


try going to tools, options,calculation, be sure calculation are set to
automatic


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=519944

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
http://www.mvps.org/dmcritchie/excel/join.htm#trimall

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

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

"Jennifer H" wrote in message ...
Tried that yesterday, didn't do anything. Thanks for your help, though! Any
other ideas?

Change 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




"Jennifer H" wrote in message
...
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?