I have a source data sheet, and a pivot table report which pulls from the
data sheet. The report also has some calculated field in it. When I
"refresh" my report after changing or adding data in the data source, the
report deletes the columns being pulled from the data sheet, puts #NAME? in
all the calculated field columns and give me a message " do you want to
replace the contents of the destination cells.. yes or no". Clicking either
yes or not does not restore the columns.

I'm using Excel 2003.