General discussion
February 7, 2002 at 10:38 PM
dbc

Excel not calculating correctly

by dbc . Updated 24 years, 6 months ago

The Finance Dept computers run Excel 2000 in a Windows 98 environment. Spreadsheets that must calculate are normal procedure. Recently, however, when they have gone to replace numbers in reusable spreadsheets, the figures have not calculated correctly. If we highlight the set of cells from top to bottom and use the Autosum, the total will not be correct. F-9 to recalculate does not work. There are no formulas in those particular cells. We have even copied and pasted to another place on the spreadsheet and it still miscalculates. Totally clearing the cells and re-entering data does not help. The only way to get a correct total is to manually insert it. No luck looking for answers on the MS Excel website. We are desperate for an answer as the Finance Dept. runs on these spreadsheets!

This discussion is locked

All Comments