I
IVCC
My worksheet has several rows of data and I am trying to use the autosum tool
in the ribbon it is not consistant, sometimes it will calculate the sum and
other times it puts the formula in the where the sum should be. If I use the
copy function from one that worked and paste into one that didn't it
magically returns a result. Why won't the autosum work?
1) Some of your cells are formatted as text.
Some of these worksheets were created in Excel 2003 and the data
did not retain it's format when opened in Excel 2007. Is there something one
can do to a file in 2003 prior to opening in 2007 to make it retain it's
former data types?
2) You have calculation set to manual. In previous versions this could be
found at Tools>Options>Calculations Tab.
In Excel 2007 the default is Automatic
in the ribbon it is not consistant, sometimes it will calculate the sum and
other times it puts the formula in the where the sum should be. If I use the
copy function from one that worked and paste into one that didn't it
magically returns a result. Why won't the autosum work?
1) Some of your cells are formatted as text.
Some of these worksheets were created in Excel 2003 and the data
did not retain it's format when opened in Excel 2007. Is there something one
can do to a file in 2003 prior to opening in 2007 to make it retain it's
former data types?
2) You have calculation set to manual. In previous versions this could be
found at Tools>Options>Calculations Tab.
In Excel 2007 the default is Automatic