View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Copying cells- the cell references don't update

Sarah

Re-read the response from Gary's Student about the order in which you open
workbooks and what Calc Mode Excel defaults to.


Gord Dibben MS Excel MVP

On 21 Jan 2007 09:33:51 -0800, "Sarahj" wrote:

Can anyone throw any light
on how the setting had become changed to Manual? I certainly did not
consciously change it.