Thread: Copied formula won't calculate
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Copied formula won't calculate
Turn calculation mode to automatic under ToolsOptionsCalculation.


Gord Dibben MS Excel MVP

On Wed, 1 Aug 2007 09:08:03 -0700, Lisar.
wrote:

When I copy and paste a formula to a new cell, the new cell will show the
result from the original location.

Reply With QuoteReply With Quote