Re: Excel (re)calculation not recalculating

["Mark Allen" <scprideandms@xxxxxxxxx>]

F9

On 9/4/07, daparnin@xxxxxxxxxxxxxx <daparnin@xxxxxxxxxxxxxx> wrote:
> We have a person who has put together an Excel spreadsheet that isn't
> recalculating properly.  They have copied a couple of columns to a new
> spot.  The second column multiplies the value in the first column by a
> cell in another column.  When the value in the first column is changed the
> sum in the second column remains the same.  If you press F2 on the second
> column cell to edit it and then press ENTER it will recalculate the value
> at that time.
>
> What could be preventing the recalculation from happening in the first
> place?  Is there a way to manually tell Excel to recalculate the entire
> spreadsheet?  Thanks.
>
>
> Dave Parnin
> --
> Nishikawa Standard Company
> Topeka, IN  46571
> daparnin@xxxxxxxxxxxxxx
> --
> This is the PC Technical Discussion for iSeries Users (PcTech) mailing
> list
> To post a message email: PcTech@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/pctech
> or email: PcTech-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/pctech.