Thanks Jeff. That's a start but not quite answered the question. I'll try to go into a bit more detail, I can't share any workbooks though.
We have a whole suite of workbooks published to the server which use the same data source in this way. They are published Extracts with nightly refresh schedules.
So within these workbooks are certain custom groupings defined by Calculated Fields. Occasionally the powers-that-be decide to add or remove members from the custom group so we have to go into every workbook and alter the calculated field
What we would like to be able to do is edit the group in a central location so that all the other workbooks attached to it will update accordingly. At the moment it will only allow me to edit a copy of the calculated field and not replace all references to it across the whole server
as I see it I'd still have to go into each workbook, create a copy, alter the formula, replace the references and republish the workbook. Which is painstaking in the least.
I could keep a copy of the data source disconnected from the server, make the changes there and then overwrite the data source on the server but then I lose all the custom aliases and in some cases parameter connections for some reason?
that's the beauty of the data server. You can create groups / calcs / etc in the datasource, publish it up to server, and then all the workbooks point at this datasource. As groups evolve (within the published datasource), the workbooks will reflect this.
Watch this video: Data Server | Tableau Software