I've run into the same issue with connections to SAS datasets (in pivot tables and tables.) Unfortunately, I did not find a way. I had to create a new table and then point the calculations to the new table. You can often do this as a global change in the worksheet(s) with the formulas, but not always. I'll be paying attention to see if someone has a solution.