Thread: formulas do not copy to destination cells, but as existing totals
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten Niek Otten is offline
external usenet poster
  
Posts: 3,440
Default formulas do not copy to destination cells, but as existing totals
ToolsOptionsCalculation tab, check Automatic

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"linky" wrote in message ...
| formulas entered in origin cells are copied to destination cells, to give
| automatic total in dest.cell eg. =C4/114% - but instead of doing this,
| as it always has, excel now copies only my origin totals, to all destination
| cells, and ignores the formulae.


Reply With QuoteReply With Quote