software

I have my spreadsheet calculation properties set as Automatic. When I close
the spreadsheet with the quot;Savequot; command it saves and closes. When I close
the spreadsheet with the quot;Save Asquot; command with a new name it recalculates
with a new dollar amount. Why doesn't it recalculate when command quot;Savequot; is
used?

What you say is happening is not supposed to happen. I can only assume that
what you say is happening is not what is happening..
You say when you close your file with the Save command, the file saves and
closes. This does not happen that way. The Save command saves the file.
It does not close the file.
I understand you to say that when you save with Save and then save with
SaveAs, the value in some cell ends up different in the two files. Is that
correct?
If so, provide details about what is in that cell. HTH Otto

quot;JennyZurbquot; lt;u16877@uwegt; wrote in message news:592f126fa73dc@uwe...
gt;I have my spreadsheet calculation properties set as Automatic. When I
gt;close
gt; the spreadsheet with the quot;Savequot; command it saves and closes. When I close
gt; the spreadsheet with the quot;Save Asquot; command with a new name it recalculates
gt; with a new dollar amount. Why doesn't it recalculate when command quot;Savequot;
gt; is
gt; used?
OK I hit Save and then close the program myself it does not change the value.
When I Save As with a different name or in a different location it calculates.Otto Moehrbach wrote:
gt;What you say is happening is not supposed to happen. I can only assume that
gt;what you say is happening is not what is happening..
gt;You say when you close your file with the Save command, the file saves and
gt;closes. This does not happen that way. The Save command saves the file.
gt;It does not close the file.
gt;I understand you to say that when you save with Save and then save with
gt;SaveAs, the value in some cell ends up different in the two files. Is that
gt;correct?
gt;If so, provide details about what is in that cell. HTH Otto
gt;
gt;gt;I have my spreadsheet calculation properties set as Automatic. When I
gt;gt;close
gt;[quoted text clipped - 3 lines]
gt;gt; is
gt;gt; used?

--
Message posted via OfficeKB.com
www.officekb.com/Uwe/Forums.a...excel/200512/1