Calculate Sheets separately

I have an Excel workbook that has over 20 tabs each of which contains calculations for thousands of records imported from access.

When i refresh the imported access table in Excel, it wants to calculate every formula in the entire workbook rather than only the formulas associated with the data table that i just refreshed.

is there a way to tell Excel, maybe in a macro, to only refresh the worksheet(s) that get their data from whichever access table i just refreshed?

also, it seems like when i put manual calculations on and i select only one column to calculate, Excel will still attempt to refresh the entire workbook - which in this case takes about 30 minutes.

thanks

I just found the "Calculate Sheet" button. seemed to have helped quite a bit.. i suppose i could incorporate that into a macro