new problem copying formulae

%3CLINGO-SUB%20id%3D%22lingo-sub-1388596%22%20slang%3D%22en-US%22%3Enew%20problem%20copying%20formulae%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1388596%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3EI%20use%20Excel%20frequently%2C%20and%20I%20know%20how%20to%20copy%20and%20paste%20cells%2C%20including%20those%20with%20formulae.%20But%2C%20as%20of%20yesterday%2C%20when%20I%20do%20so%2C%20even%20though%20the%20copied%20formula%20still%20displays%20the%20next%20row%2Fcolumn%20(as%20it%20is%20supposed%20to)%2C%20the%20value%20displayed%20is%20that%20of%20the%20original%20cell.%3C%2FP%3E%3CP%3EEg%2C%20if%20A1%20contains%20Smith%20and%20B1%20Brown.%3C%2FP%3E%3CP%3EIf%20I%20entered%20at%20A2%20the%20formula%20%3DA1%2C%20I%20would%20get%20Smith%20displayed%20in%20the%20cell%20(correctly)%2C%20but%20when%20I%20copy%20A2%20into%20B2%20I%20get%20the%20formula%20%3DA2%20but%20the%20displayed%20value%20is%20Smith%2C%20not%20Brown.%3C%2FP%3E%3CP%3EThe%20same%20issue%20occurs%20on%20using%20the%20fill%20handle.%20Or%20on%20copying%20a%20sheet.%3C%2FP%3E%3CP%3EI%20have%20never%20seen%20this%20behaviour%20before.%20No%20%24%20signs%20added%20anywhere.%20In%20desperation%20I%20have%20explored%20all%20the%20different%20paste%20options%2C%20but%20no%20better.%20What%20is%20going%20on%3F!%3C%2FP%3E%3CP%3EThank%20you%2C%20Ruth%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1388596%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1393968%22%20slang%3D%22en-US%22%3ERe%3A%20new%20problem%20copying%20formulae%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1393968%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F667450%22%20target%3D%22_blank%22%3E%40Ruth_Broadbent%3C%2FA%3E%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I%20feel%20that%20your%20Calculation%20option%20might%20be%20set%20to%20%3CSTRONG%3EManual%3C%2FSTRONG%3E%2C%20please%20set%20it%20to%20%3CSTRONG%3EAutomatic%3C%2FSTRONG%3E%20%26amp%3B%20it%20should%20work%20fine.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EGoto%20%26gt%3B%20Formula%20%26gt%3B%20Calculation%20Options%20%26gt%3B%20Automatic%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222020-05-15_23-16-00.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F192140i60C26DADC72C8CCC%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%222020-05-15_23-16-00.png%22%20alt%3D%222020-05-15_23-16-00.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%20Answer%26nbsp%3Bto%20help%20the%20other%20members%20find%20it%20more%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hello

I use Excel frequently, and I know how to copy and paste cells, including those with formulae. But, as of yesterday, when I do so, even though the copied formula still displays the next row/column (as it is supposed to), the value displayed is that of the original cell.

Eg, if A1 contains Smith and B1 Brown.

If I entered at A2 the formula =A1, I would get Smith displayed in the cell (correctly), but when I copy A2 into B2 I get the formula =A2 but the displayed value is Smith, not Brown.

The same issue occurs on using the fill handle. Or on copying a sheet.

I have never seen this behaviour before. No $ signs added anywhere. In desperation I have explored all the different paste options, but no better. What is going on?!

Thank you, Ruth

1 Reply
Highlighted

hi @Ruth_Broadbent

 

What I feel that your Calculation option might be set to Manual, please set it to Automatic & it should work fine.

 

Goto > Formula > Calculation Options > Automatic

 

2020-05-15_23-16-00.png

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more