If your calculation settings are set for automatic, not manual, then I can't tell what is going on. I checked this in version 2003, not 2002, so I don't know if that "Tools/Options/" option is there for the 2002 version. In the 2003 version the behavior is exactly what you experience in your version. I hope this helps.
Pablo Rivera =========== * -----Original Message----- * From: [EMAIL PROTECTED] * [mailto:[EMAIL PROTECTED] On Behalf Of MB * Software Solutions * Sent: Wednesday, June 13, 2007 10:32 PM * To: [EMAIL PROTECTED] * Subject: [NF] Problem with Excel 2002 copied cell formulas * not working untiledited! * * Weird one! I copy a cell with a simple formula to rows * beneath it, and the pasted rows don't get the proper value * until I edit the cells individually! * * * Check it out here: * http://mbsoftwaresolutions.com/demos/excel_weirdness_viewlet_swf.html * * Tia! * --Michael * * -- * Michael J. Babcock, MCP * MB Software Solutions, LLC * http://mbsoftwaresolutions.com * http://fabmate.com * "Work smarter, not harder, with MBSS custom software solutions!" * * * [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
