Hi all,
I've got a problem with Excel which has been bugging me for months. First I thought it was system specific or version specific, but in the meantime I've switched employers and with that from Excel 2007 to 2010 and the problem is still. I've read many possible solutions, but they all seem to lead to macro based problem which this is not. I can reproduce the problem very easily so I'll describe them below. The problem is as the title states that Excel chooses to switch to Manual Calculation upon reopening a document when saved in a specific, though regularly used way (in my case that is). These are the steps:
- Make sure no workbooks are open and open a new workbook. By default it opens with 3 sheets, otherwise add some.
- Place on any cell of each sheet some text/data/whatever so that a printjob won't ignore the page while printing.
- Select all sheets (if you don't know how to do this you probably can't help me)
- Print these sheets (choose a pdf printer to not waste any paper) by default settings. (All selected will be printed as one document)
- After that close Excel, without deselecting the sheets or anything. The program asks you to save; do that to whichever location.
- After Excel is closed, reopen the document. You'll notice all sheets are still selected.
- Check Calculation Options: it has been switched to manual. (At least in all my experiences)
Let me be clear: I do not want Excel to do this.
Does someone have a solution for this? My apologies if this had already been discussed; I couldn't find it.
Thanks in advance for thinking with me
EDIT: edited the first step to clarify that no workbooks should be opened
Bookmarks