T
Ted
I have a database that is entirely dependant on an Excel
workbook and 14 worksheets through linked tables. The
spreadsheet is used to forecast needed 'employees' on a
given date. It uses the actual data that is entered in
the access form to make this calculation. Example: On
4/19 there were 36 employees on 4/20 it is forecasted that
there is a need of 35 employees. So, cell B2 contains the
value 36, while cell B3 contains a formula. As a person
enters data the formulas should be overwritten for each
day's actual data. My form shows the values and the
worksheet is doing its job. Problem: Access will not
allow the information in "cell B3" to be overwritten -
error message "unable to update field" the help says that
it is 'in use' or 'locked' neither is the case.
Please Help!!
workbook and 14 worksheets through linked tables. The
spreadsheet is used to forecast needed 'employees' on a
given date. It uses the actual data that is entered in
the access form to make this calculation. Example: On
4/19 there were 36 employees on 4/20 it is forecasted that
there is a need of 35 employees. So, cell B2 contains the
value 36, while cell B3 contains a formula. As a person
enters data the formulas should be overwritten for each
day's actual data. My form shows the values and the
worksheet is doing its job. Problem: Access will not
allow the information in "cell B3" to be overwritten -
error message "unable to update field" the help says that
it is 'in use' or 'locked' neither is the case.
Please Help!!