Touch all the worksheets in your workbook (just click on each worksheet) before replacing the data source and closing the old data source.
pardon me...let's say I have one worksheet with one data source.
my manager has not sent a new data source (same info, but different layout).
I have about half dozen calculated fields and I would like to keep and edit vs. starting from scratch to write them...
Do you have a sample workbook?
I just retyped, copied and pasted and changed the Field Name (when I changed the Data Source, I lost all the calculated fields...)