View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Formulas in 2007 not working in 2003

On Mon, 28 Jan 2008 08:55:02 -0800, Andrew
wrote:

Ron

It is calculating 7 -- the number of "New Facility" in G
--
Andrew



In your 2003 workbook

Select Tools/Options/Transition/Workbook Options and DEselect Transition
Formula Evaluation. (You should probably also DEselect Transition Formula
Entry if it is selected).
--ron