My Excel mortgage spreadsheet

Locoblade · 14 September 2008 at 9:02PM

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 · 14 September 2008 at 9:05PM

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 · 14 September 2008 at 9:08PM

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 · 14 September 2008 at 9:11PM

open office or microsoft works

Locoblade · 14 September 2008 at 9:20PM

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 · 14 September 2008 at 9:25PM

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 · 14 September 2008 at 9:31PM

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 · 14 September 2008 at 9:38PM

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 · 14 September 2008 at 9:46PM

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 · 14 September 2008 at 9:50PM

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.

My Excel mortgage spreadsheet - Page 2

MSE Highlights 21/4

My Excel mortgage spreadsheet

Replies

Quick links