A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
If its not working in the old workbook, and since you have copied everything over to new workbook the best option would be to save the new workbook and work on it...
Why it does not work i have no explanation...