Hi,

I have multiple excel data tables located on one spreadsheet. In order to keep my machine from freezing up, I currently have my calculation option set to "Automatic except Data Tables" Whenever I make changes and need to update the table, I switch this selection to automatic, and then back to automatic except data tables when calculations are completed.

I was wondering if anybody know how to create a button (macro?) that will allow me to refresh data tables on the worksheet by pressing it, instead of having to go through all the excel menus.

thanks!