I have made a a metric to a spreadsheet and want to do the same with another one exactly like it.

When I had copied over the spreadsheet with all the countif formulas in it the formula changed and added the title of the spread sheet I had taken it from.

For example this is the original formula:
=COUNTIF(KettleCheck!C4:C121,">="&DATE(2011,1,1))-COUNTIF(KettleCheck!C4:C121,">="&DATE(2011,1,32))

This is the formula after I copied it into the next workbook:
=COUNTIF('[Production Certification Records]KettleCheck!C4:C121,">="&DATE(2011,1,1))-COUNTIF('[Production Certification Records]KettleCheck!C4:C121,">="&DATE(2011,1,32))

I want to remove the '[Production Certification Records] without having to do this by hand on each one, for there are over 500 cells with this problem.

Any advise?