Autofill Excel sheet using Access form

[murpl]

I've built an Excel 2K sheet and linked an Access (also 2000) form for the user to add/edit records. The problem is in getting Excel to autofill the formulas for each new record using the Access form. If I enter data directly into the Excel sheet it works fine.
Do I have to manually fill the spreadsheet formulas in order for the access form input to work right or is there a way I can let the spreadsheet grow as records are added and still use my Excel calculations?

Thanks,
Mike