Your browser isn't supported
It looks like you're using an old web browser. To get the most out of the site and to ensure guides display correctly, we suggest upgrading your browser now. Download the latest:

Welcome to the MSE Forums

We're home to a fantastic community of MoneySavers but anyone can post. Please exercise caution & report spam, illegal, offensive or libellous posts/messages: click "report" or email forumteam@.

Search
  • FIRST POST
    • MSE Archna
    • By MSE Archna 2nd Jan 08, 7:10 PM
    • 1,872Posts
    • 5,996Thanks
    MSE Archna
    Budget Planner Spreadsheet Help Thread
    • #1
    • 2nd Jan 08, 7:10 PM
    Budget Planner Spreadsheet Help Thread 2nd Jan 08 at 7:10 PM


    This thread is specifically so you can
    Ask questions/discuss technical issues about the Budget Planner spreadsheet
    that's in
    The Budget Planner: Free budgeting tool and special piggybanking system

    IMPORTANT. This is only for technical questions.

    Alternative discussions

    Discuss the Online version
    Discuss the Spreadsheet version

    Read the article first. If you still have any problems, then click reply to discuss below.
    Last edited by Former MSE Ian; 20-03-2012 at 11:23 AM.
    Report inappropriate posts: forumteam@moneysavingexpert.com




Page 1
  • DenBo
    • #2
    • 2nd Jan 08, 8:54 PM
    • #2
    • 2nd Jan 08, 8:54 PM
    I understand about the Piggybanking technique but what if you can't open six accounts in a bank/banks? I can't as my credit rating is too bad, I have one bank account but can't open any more, no one will have me!
    • Eggfoot
    • By Eggfoot 3rd Jan 08, 11:59 PM
    • 1 Posts
    • 1 Thanks
    Eggfoot
    • #3
    • 3rd Jan 08, 11:59 PM
    Problems with Spreadsheet
    • #3
    • 3rd Jan 08, 11:59 PM
    Hello

    Im trying to add more rows to the "Enter Other Income Source" part of the spreadsheet, but its not allowing me to do so...saying that the page is "protected". When I try to "Unprotect" it prompts me for a password. Which i obviously dont have.

    Im using the spreasdsheet in Office 2007...could this be the problem?
  • curlytops
    • #4
    • 4th Jan 08, 7:55 PM
    Adding rows?
    • #4
    • 4th Jan 08, 7:55 PM
    :confused:
    Same problem as Eggfoot. Been trying every whichway to add rows, so would also appreciate some help.
  • laganuk
    • #5
    • 8th Jan 08, 12:05 PM
    • #5
    • 8th Jan 08, 12:05 PM
    I believe you all know what issues i am going to raise here:
    On the What Do You Earn pane there are no I, J and K columns thus the formula that includes to I108:K108 for example appears to be wrong.
    When i use it it gives me #REF! error.
  • Former MSE James
    • #6
    • 8th Jan 08, 12:52 PM
    • #6
    • 8th Jan 08, 12:52 PM
    I believe you all know what issues i am going to raise here:
    On the What Do You Earn pane there are no I, J and K columns thus the formula that includes to I108:K108 for example appears to be wrong.
    When i use it it gives me #REF! error.
    Originally posted by laganuk
    This is an interesting one... What version of Excel/Open Office are you using? Would it be possible to post a screenshot of this, obviously removing any personal data before hand..
  • laganuk
    • #7
    • 8th Jan 08, 1:33 PM
    • #7
    • 8th Jan 08, 1:33 PM
    MS Excel Office 2003.
    Screen capture doesn't seem to work but it was a good idea!! I even tried to put it on Google Docs ... lol


    The top runs from ... E F L M N ....
    Im in Part B and the formula starts with =(SUM(I108:K108)>1, "ERROR" ....
    Needless to say repayments total is #REF! too
    Last edited by laganuk; 08-01-2008 at 1:47 PM. Reason: Print screen doesn't work
  • cityzencraig
    • #8
    • 8th Jan 08, 1:34 PM
    Spreadsheet Budget Planner
    • #8
    • 8th Jan 08, 1:34 PM
    The budget planner is a great tool.
    I was thinking of modifying it to enter dates for income and bank-automated expenditure so I can visualise my net worth weekly and restirct other spending.
    Is there any chance you can provide the password to unprotect the workbook?:rolleyes:
    • polkadot
    • By polkadot 9th Jan 08, 9:32 AM
    • 1,842 Posts
    • 16,246 Thanks
    polkadot
    • #9
    • 9th Jan 08, 9:32 AM
    Downloading the budget planner
    • #9
    • 9th Jan 08, 9:32 AM
    Hi All

    Ive downloaded the budget planner spreadsheet, but I get a notification that it is read only. When I try to unprotect it using the review tab, Im asked for a password. Have I done something wrong when I downloaded?
    • MSE Martin
    • By MSE Martin 9th Jan 08, 9:52 AM
    • 8,109 Posts
    • 42,244 Thanks
    MSE Martin
    Hi All

    Ive downloaded the budget planner spreadsheet, but I get a notification that it is read only. When I try to unprotect it using the review tab, Im asked for a password. Have I done something wrong when I downloaded?
    Originally posted by polkadot
    My guess is you've just clicked it; rather than right click and saved it?

    Martin
    Martin Lewis, Money Saving Expert.
    Please note, answers don't constitute financial advice, it is based on generalised journalistic research. Always ensure any decision is made with regards to your own individual circumstance.

    Don't miss out on urgent MoneySaving, get my weekly e-mail at www.moneysavingexpert.com/tips.

    Debt-Free Wannabee Official Nerd Club: (Honorary) Members number 000
    • polkadot
    • By polkadot 9th Jan 08, 10:11 AM
    • 1,842 Posts
    • 16,246 Thanks
    polkadot
    Hi Martin

    Tried again, right clicked and saved as but it's still password protected
    • polkadot
    • By polkadot 9th Jan 08, 10:13 AM
    • 1,842 Posts
    • 16,246 Thanks
    polkadot
    Ah, no you were right. It's working now. Thank you very much
  • dimarian
    budget planner
    hi
    i am totally new to this site but its just what i am looking for. however, i have tried to use the budget planner but it doesn't allow me to insert numbers. i read the other threads and can't seem to see if there is any solution any help would be appreciated
    • polkadot
    • By polkadot 10th Jan 08, 11:47 PM
    • 1,842 Posts
    • 16,246 Thanks
    polkadot
    Hi Dimarian
    I had the same prob and turned out I wasnt downloading correctly. Instead of clicking on it like you normally do to download, you need to right click and save as (some new systems quote "save target as" then choose a place on your pc to save it to. I saved mine on the desktop, have only had it two days and have been into it a number of times.
  • mjk
    Hi,

    I've downloaded the spreadsheet and am able to use it on my pc. However, I just tried to email my updated version to my brother (I'm trying to help him sort out his budget), and it didn't send. I got a message saying:

    Some of the files could not be found and could not be attached to the message. Would you like to send the message anyway?

    I hit "yes", and the message was sent without the attachment. Is there something I'm doing wrong, or is it not possible to email it? I was hoping we'd be able to send it backwards and forwards between us as we made changes and suggestions.

    Thanks for any help.
  • Speranza
    Same problem here
    [quote=polkadot;7764933]Hi All

    Re need for password to unlock spreadsheet -

    Just wondering if you've found a solution yet, as I've hit the same problem, though I definitely did right click and 'save as'. Frustrating!
  • Excel1
    Password problem
    [quote=Speranza;7873053]
    Hi All

    Re need for password to unlock spreadsheet -

    Just wondering if you've found a solution yet, as I've hit the same problem, though I definitely did right click and 'save as'. Frustrating!
    Originally posted by polkadot
    Exactly the same problem! :confused:
  • demelza
    password request
    I have now right clicked several times and am still getting the protected item message and i need a password. Twice when I've opened the download its just been gobbledegook that has opened. Do I need to go through internet explorer instead of Mozilla Firefox? I've been trying for over an hour and I really really really am right clicking.
    Last edited by demelza; 20-01-2008 at 2:30 AM. Reason: need to change subject
  • a11waysindebt
    You might have to download this if you haven't got excel

    http://www.moneysavingexpert.com/shopping/free-office-software
  • demelza
    down loading the budget planner
    Dear allthewaysindebt

    Thanks for that but I do have excel and I clicked on your link and there was so much info on that page, nothing that seemed to be anything to click on to down load, seemed more of a forum. I've worked 110 hrs in the last 2 wks, I just want to be able to get on with it. Please help.
Welcome to our new Forum!

Our aim is to save you money quickly and easily. We hope you like it!

Forum Team Contact us

Live Stats

257Posts Today

1,218Users online

Martin's Twitter
  • RT @LordsEconCom: On Tuesday Martin Lewis, Hannah Morrish & Shakira Martin gave evidence to the Cttee. Read the full transcript here: https?

  • Ta ta for now. Half term's starting, so I'm exchanging my MoneySavingExpert hat for one that says Daddy in big letters. See you in a week.

  • RT @thismorning: Can @MartinSLewis' deals save YOU cash? ???? https://t.co/igbHCwzeiN

  • Follow Martin