When you open an Excel 2002 or an Excel 2003-protected sheet in Excel 2000 or earlier, the Excel 2003 protection functionality reverts back to the level of protection that was available in that version of Excel. Generally, the new protection features in Excel 2002 and in Excel 2003 are exceptions to the default level of protection. In other words, if you use Excel 2000 to open a workbook that was created in Excel 2003, you are not allowed to make changes that are protected in Excel 2003. Protection options (for example, enabling Insert columns on a protected sheet) do not apply to earlier versions
bubblesmoney wrote: »
nice work chris.
is it possible to choose a daily interest calculation option for the calculator? also is it possible to compare different mortgage providers packages by having an option for factoring in their fees for the mortgage?
Locoblade wrote: »
Looks like it will only work with Excel 2002 and newer.....http://support.microsoft.com/kb/826923
I'll see if I can work out one thats compatible with 2000 or earlier(:eek: ), I suspect some of the equations etc used will screw up in really early versions of Excel anyway, so it might not be possible.
Locoblade wrote: »
Just to note, the first proper bug has been found (thankyou lagi).
If you have a mortgage that has a a split rate, with say 5 years at 5% followed by the remainder at 6%, when you put something like £200 a month in the monthly overpayment box, it won't change the basic payment to the new rate after 5 years, so from year 5 to the end of the loan, it effectively underpays the mortgage slightly and uses some of the overpayment to make up the shortfall, in effect reducing the amount you're actually overpaying.
I'll have a look at rectifying this tonight, so if anyone is planning on spending time putting in their own mortgage figures from years past, you may want to wait for v1.1
...after Rage Against The Machine pulls out
Check out last week's energy-themed Q&A with MSE's experts
Where to get your culture fix across the UK