| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bug? Autocalculation turns itself on...
Hi, folks,
The kind of job I do needs to be using manual calculation almost full-time. Well, the problem is: I want to always use Manual Calculation option (without "recalculate before save" option checked). But sometimes Excel itself insists to change that option *without being requested to* :) And sometimes I find it out a little too late... Is this any kind of bug? Is anyone having that problem too? How do I fix this and turn Excel into a more appropriate friend? :))) Thanks and regards! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Bug? Autocalculation turns itself on...
ops... forgot to say: Microsoft Office Excel 2003
;) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Bug? Autocalculation turns itself on...
If you open a workbook with auto calculation on first and then open your manual calc workbook, Excel will use the setting of the
first one. -- Kind regards, Niek Otten Microsoft MVP - Excel "Raffael" wrote in message ... | Hi, folks, | | The kind of job I do needs to be using manual calculation almost full-time. | | Well, the problem is: I want to always use Manual Calculation option | (without "recalculate before save" option checked). But sometimes Excel | itself insists to change that option *without being requested to* :) | And sometimes I find it out a little too late... | | Is this any kind of bug? | Is anyone having that problem too? | | How do I fix this and turn Excel into a more appropriate friend? :))) | | Thanks and regards! | | |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Bug? Autocalculation turns itself on...
ooooh... so this is a "per-workbook" setting?!
Thought it was a general/global definition... =/ Anyway... thanx! "Niek Otten" escreveu na mensagem ... If you open a workbook with auto calculation on first and then open your manual calc workbook, Excel will use the setting of the first one. -- Kind regards, Niek Otten Microsoft MVP - Excel "Raffael" wrote in message ... | Hi, folks, | | The kind of job I do needs to be using manual calculation almost full-time. | | Well, the problem is: I want to always use Manual Calculation option | (without "recalculate before save" option checked). But sometimes Excel | itself insists to change that option *without being requested to* :) | And sometimes I find it out a little too late... | | Is this any kind of bug? | Is anyone having that problem too? | | How do I fix this and turn Excel into a more appropriate friend? :))) | | Thanks and regards! | | |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Bug? Autocalculation turns itself on...
It's a global setting. But that setting is determined by the first workbook you
open in that session. Raffael wrote: ooooh... so this is a "per-workbook" setting?! Thought it was a general/global definition... =/ Anyway... thanx! "Niek Otten" escreveu na mensagem ... If you open a workbook with auto calculation on first and then open your manual calc workbook, Excel will use the setting of the first one. -- Kind regards, Niek Otten Microsoft MVP - Excel "Raffael" wrote in message ... | Hi, folks, | | The kind of job I do needs to be using manual calculation almost full-time. | | Well, the problem is: I want to always use Manual Calculation option | (without "recalculate before save" option checked). But sometimes Excel | itself insists to change that option *without being requested to* :) | And sometimes I find it out a little too late... | | Is this any kind of bug? | Is anyone having that problem too? | | How do I fix this and turn Excel into a more appropriate friend? :))) | | Thanks and regards! | | -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Bug? Autocalculation turns itself on...
Yeah, sure, that was pretty clear!
Thanks "Dave Peterson" escreveu na mensagem ... It's a global setting. But that setting is determined by the first workbook you open in that session. Raffael wrote: ooooh... so this is a "per-workbook" setting?! Thought it was a general/global definition... =/ Anyway... thanx! "Niek Otten" escreveu na mensagem ... If you open a workbook with auto calculation on first and then open your manual calc workbook, Excel will use the setting of the first one. -- Kind regards, Niek Otten Microsoft MVP - Excel "Raffael" wrote in message ... | Hi, folks, | | The kind of job I do needs to be using manual calculation almost full-time. | | Well, the problem is: I want to always use Manual Calculation option | (without "recalculate before save" option checked). But sometimes Excel | itself insists to change that option *without being requested to* :) | And sometimes I find it out a little too late... | | Is this any kind of bug? | Is anyone having that problem too? | | How do I fix this and turn Excel into a more appropriate friend? :))) | | Thanks and regards! | | -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Every time i type a date in a field it turns it into ###### | New Users to Excel | |||
| More than 15 digits in excel cell it turns them to zeros. Fix? | Excel Worksheet Functions | |||
| If value in column is yes; entire line turns red | Excel Discussion (Misc queries) | |||
| = sum value turns to text and formula disappears | Excel Worksheet Functions | |||
| How can I create formula that turns a date into the week # in | Excel Discussion (Misc queries) | |||
Linear Mode
