I have managed to copy a worksheet from another workbook into a master workbook.

that sheet (the copied one) contains formulas that do work correctly. Problem is, it keeps saying #REF! on the cells that contain the formula however when you press enter on that cell or rather on the formula bar, it then fixes and evaluates that formula correctly.

any ideas how to refresh the sheet or whatever when we copied it across to the master workbook?