[Help] Excel spreadsheet help

[Giraffe]

I am working on a spreadsheet and for some unknown reason it has stopped automatically calculating when I enter changes. I have had this before on large spreadsheets but never on a small spreadsheet like this. Note it calculates if I save the sheet but clearly don't want to keep doing this. Anything I can do?

 

[clapham_gull]

I am working on a spreadsheet and for some unknown reason it has stopped automatically calculating when I enter changes. I have had this before on large spreadsheets but never on a small spreadsheet like this. Note it calculates if I save the sheet but clearly don't want to keep doing this. Anything I can do?

Make sure auto calculations are turned on in options. The spreadsheet should refresh with F9.



Sent from my BTV-DL09 using Tapatalk

 

[Giraffe]

Make sure auto calculations are turned on in options. The spreadsheet should refresh with F9.



Sent from my BTV-DL09 using Tapatalk

Perfect, that's done it, no idea why it was turned off though. Odd.

 

[Guinness Boy]

Perfect, that's done it, no idea why it was turned off though. Odd.

I've had this before where the workbook I've had open previously has had macros in it. Since they are prevented from running automatically, and since some reference sheets might need to be present, Excel seems to set itself to "off" for calculations unless the macro has run. If you've been emailed a spreadsheet by someone else that had the auto calculations off, and you opened that it will do the same. Damn annoying, I've had it happen several times WRT spreadsheets sent to me by a client,

 

[Worthing exile]

Have you turned auto calculations off and on?

 

[clapham_gull]

And if no-one has already dump complex Excel formulas and especially evil macros for Power Query.

Available as an add in for earlier Excel and now called get and transform in the latest version.

You won't go back.

Sent from my BTV-DL09 using Tapatalk

 

[Deleted member 2719]

And if no-one has already dump complex Excel formulas and especially evil macros for Power Query.

Available as an add in for earlier Excel and now called get and transform in the latest version.

You won't go back.

Sent from my BTV-DL09 using Tapatalk

What are the pros and cons for Excel against Google sheets