Formulas in Excel

[Guest]

Just got a new computer with Office 2007. My problem is in Excel. I can't
transfer formulas (equations) into another 'new' 'blank' worksheet. For 11
years we've had our monthly financial statement in Excel. To start a new
year, I just transferred one month's info into the new worksheet and was
ready to go. NOW.... all the numbers, letters will transfer to the new
worksheet, but NONE of the formulas transfer.
I can transfer formulas from the worksheet to another 'sheet' within THAT
worksheet, but the formulas won't transfer from wrksht. to wrksht.
I am transferring from an old Excel program to Office 2007 Excel version.
However, I can't get this transfer of formulas to happen within the new 2007
Excel version from worksheet to another worksheet either.
There are thousands of equations in this financial statement. I just can't
re-do it every year.

 

[Guest]

Instead of transferring information and formulas from the old workbook to a
new workbook, just make a copy of the old workbook and start from there.