My Excel mortgage spreadsheet

Locoblade

Gorgeous_George wrote: »

I'm sure you will be able to open it with Open Office or GoogleDocs if you don't have Excel.

GG

Its an errant locked cell that was spotted, it wasnt that it couldnt be opened

New one now uploaded....

benbenandme

I saved it but it won't let me open it, it says its password protected or encrypted?? I'm also not at all techie so it could be me being a muppet

Locoblade

Certain cells / pages are locked so they can't be edited, but you should be able to open it no problems. What version of Excel are you using?

benbenandme

open office or microsoft works

Locoblade

Ah that may explain it then, Ive only tested it with Excel 2003 and 2007.

Anyone know whether both of those products dislike locked cells?

fattony

thanks, it looks good but would be great if I could personalise it, i.e my mortgage is 132k, is there any way I could change the 100k to 132k?

Locoblade

fattony wrote: »

thanks, it looks good but would be great if I could personalise it, i.e my mortgage is 132k, is there any way I could change the 100k to 132k?

Yes, just type over all the cells on the input page putting in your own rates, loan amounts etc etc, the £100k and all the other inputs already typed in are only there as an example!

spud30

Loco, I am using an old version of Excel and cant change any of the values on the yellow columns in the Detailed Monthly Table. Am I doing something wrong? All say password protected.

Locoblade

Hmm. There are locks on the cells that do all the calculations so they dont get over-written but the yellow columns are all editable. I can only think that older versions can't support partially locked pages so treat the whole page as locked

What version of Excel is it?

spud30

It's the 2000 version.

What a shame, I could've happily spent many hours looking at how much I've saved us over the years.

You're very clever to produce such a clever calculator.