Copying a calculator

[Guest]

Hi. I have a home loan calculator that calculates repayments and also shows
year by year the amortization. I created this in Excel 2000 and it works
fine. When I copy this calculator, it does not copy across all the
functions, named ranges etc. This happens even when I used Paste Special.
The net effect is that when I try to use the new one and put in the new loan
amount, nothing else changes. There are no named ranges etc. The only way
I can achieve what I want is to copy the workbook in its entirety and then
delete what I don't want. Now I am sure there is a better way and hope you
can point me in the right direction! Many thanks. Jazz

 

[Guest]

hi,
copy and paste is great but it does have it's limits
The file save as new name is your best idea.
because xl has trouble coping range names and functions.
but the save as trick will copy everything.