Excel asking to save but...

[SiM]

Looks as if F9 alone will also do it. Now have to get used to Enter then F9.

Shift calculates the active sheet only. Without the shift you are calculating the whole book everytime you press F9. It's more efficient to use shift

[Lucio]

Shift calculates the active sheet only. Without the shift you are calculating the whole book everytime you press F9. It's more efficient to use shift

And if you're anything like me, you'll soon get fed up of waiting 15-20 minutes for the entire spreadsheet to update. I really should stop using all these fun tools they give me and instead write a damn database query.

[Giraffe]

Indeed this is why no one takes OO seriously. I hope there is an option to correct this behavoir. The state of the sheet, as viewed by someone has changed.

If someone has auto calc off, they want to know the last state someone used it in.

If someone doesn't want a sheet to have changes saved, they mark it readonly.

Simple to 'correct' it: Tools - CellContents - untick AutoCalculate (took a bit of finding in Help) and F9 calculates.
For me it's ideal, as I want the day/date/months etc. calculated when I open up but I don't need to be asked to Save as, if the date has changed, I need 'today's' data.

In some ways I found Calc easier to use than Excel is, so it probably isn't a serious app.

[Giraffe]

Shift calculates the active sheet only. Without the shift you are calculating the whole book everytime you press F9. It's more efficient to use shift

It takes a split second as there's not a lot to do.

I've found that in Calc I can have it so that I edit the cell directly and hit Enter - job done. Calc is a lot slower than Excel: take about 12x as long to open and about the same factor (~1s) to Save; calculation is <1s so not an issue.

[MarcLister]

Turn automatic calculation off. If you are a serious spreadsheet user then you shouldn't be using automatic calculation - it's for n00bs.

I will introduce you to your new best friend: Shift+F9

Interesting. Might try that out. If just to get rid of the prompts when I open a spreadsheet to check something and get prompted to save.