Published Data Sources and Calculated Fields

Dan Chissick’s post doesn’t stop at theory, he walks you through a tested step‑by‑step process for “moving” calculated fields from the published data source into your workbook (so they become editable again), while preserving connections and maintaining consistency. Knowing how and when to place your calculations (in source vs workbook), and how to undo mistakes can save you hours and help avoid subtle bugs. Dive in and you’ll gain control over calculations instead of being controlled by them!