Updating tables with external data

[investorguynyc]

I am using an ODBC connection to pull data into my excel tables. I update the data regularly and when I do all the formulas referencing the data in the tables are now giving me #ref errors.

Is there a better way to update a table with appended formulas so that it does not blow up on me?

Thanks

Larry