i have a workbook of about 16 sheets including pivot tables.
If i make a copy of this can i:

1) add data to the original but then copy the 'data ONLY' to the copy book.

2) if my original formulas become corrupt but the data is still there can i somehow merge the good formulas from the copy book with the large amount of data in the original book.

3) this what has happened, when opening the book, i get an error message and it offers to fix it, but i end up with my data but all the formulas are wrong.

4) i do have a copy of the original without data and i have the now useless original with data but suspect formulas, how can i proceed? PLEASE