We’d like to remind Forumites to please avoid political debate on the Forum.

This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.

📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide

Excel Spreadsheets

2»

Comments

  • 0james0
    0james0 Posts: 527 Forumite
    Part of the Furniture 100 Posts Name Dropper Combo Breaker
    **Update***

    It now works! :D

    However, I now have a new (probably easy to fix) problem. -It doesn't update the answer to the formula until I save the document. Is there a way around this? A button to tick/ untick somewhere?

    Thanks for all of your help, it is very appreciated
    Saving and spending in equal measure
  • What version of Excel are you using? You might need to set it to update calculations automatically.
  • 0james0
    0james0 Posts: 527 Forumite
    Part of the Furniture 100 Posts Name Dropper Combo Breaker
    2003.

    My spreadsheet looks so slick now, I can't thank you guys enough for the help.
    Saving and spending in equal measure
  • Take a look in Tools > Options then the Calculations tab and see if there's a check in the Automatic option or not
  • 0james0
    0james0 Posts: 527 Forumite
    Part of the Furniture 100 Posts Name Dropper Combo Breaker
    anewhope wrote: »
    Take a look in Tools > Options then the Calculations tab and see if there's a check in the Automatic option or not

    That's the one! Thanks. :D
    Saving and spending in equal measure
This discussion has been closed.
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 354K Banking & Borrowing
  • 254.3K Reduce Debt & Boost Income
  • 455.3K Spending & Discounts
  • 247K Work, Benefits & Business
  • 603.7K Mortgages, Homes & Bills
  • 178.3K Life & Family
  • 261.2K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.1K Discuss & Feedback
  • 37.7K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.