I have a problem with an Excel file that until recently has worked well for
years. This file is a personnel master file that has been carried over from
year to year and which computes payroll and benefits for each employee.

The file contains a large number of vlookup formulas that pull data from a
variety of sources. When I carried over the file into 2007, the vlookup
formualas and subtotal functions stopped updating. I am able to force the
update on a cell by cell basis by double clicking in the cell. After I do
this the cell in question provides the correct answer.

I have no idea why these formulas are not automatically updating for new
data. the automatic recalculation box is checked in the Tools -
Option-Calculation dialog box.

I would appreciate any insights into this problem