Microsoft Excel for Mac Copy Problem

[evanskl]

I'm trying to copy a formula to a series of cells, but I'm having a problem in that it is copying the formula correctly (updates the cell address as expected) but the value being shown in the copied to cells is the value of the original cell. In other worlds the formulas are correct, but the answers are not.

Help! TIA

 

[chabig]

If the answers are wrong, the formulas are wrong. Carefully check the cell references. If you can't find the error, post a screenshot so we can all see.

 

[evanskl]

Here's the screen shot. For some reason I copies the formula to the first 23 rows and it worked just fine, but when I went to continue the copy process the second time......this is what I'm getting. I've saved the file, closed the file, shut down excel and reopened all....still having the same problem. It is a super large spreadsheet, between 3000 and 4000 rows....I hope to get it fixed without starting all over.

 

[chabig]

Excel help says that the CONCATENATE function is deprecated beginning with Excel 2016, Excel Mobile, and Excel Online. It has been replaced with the CONCAT function. You might try that instead.

But you don't even have to use functions. Just set the formula to =D28 & ", " & C28

 

[evanskl]

Thank you!
[doublepost=1535486202][/doublepost]well, CONCAT does the same thing......I'll try your second suggestions....
[doublepost=1535489243][/doublepost]and so does your suggestion..just doesn't work......same problem with all threes attempts. The spreadsheet must corrupted.

 

[bernuli]

Here's the screen shot. For some reason I copies the formula to the first 23 rows and it worked just fine, but when I went to continue the copy process the second time......this is what I'm getting. I've saved the file, closed the file, shut down excel and reopened all....still having the same problem. It is a super large spreadsheet, between 3000 and 4000 rows....I hope to get it fixed without starting all over.

View attachment 778361

I think you should only do the paste once. Select the first cell, is it maybe B2, that contains the formula, select COPY from edit menu or use shortcut. Then scroll to the bottom, hold down shift and click the last cell where you want to formula to go. All cells will be highlighted. THEN paste.

 

[evanskl]

Bernuli, that was a good though, but still getting the same result....different formulas in each row but the value of the first row in every one of the cells.

I've attempted using the formula and the copy and past in a new column....same result very time. Time to try a new spreadsheet....I'll let y'all know what happens.

 

[ftaok]

On Windows Excel, if I see something like this happen, it's usually because the 'Workbook Calculation' got flipped from 'automatic' to 'manual'. Happens all the time for no apparent reason.

Hit F9 (or perhaps fn-F9) to perform a 'calculate now'. Also, go into the Options>Formulas>Calculations options and turn on automatic calculation.

 

[evanskl]

Hallelujah! That worked!! I really was stuck...I just about trashed a 3750 line spreadsheet! Thank you!

 

[ftaok]

Hallelujah! That worked!! I really was stuck...I just about trashed a 3750 line spreadsheet! Thank you!

What worked? The calculate now, or something that bernuli suggested?

 

[evanskl]

What worked? The calculate now, or something that bernuli suggested?

Sorry I was so excited!! The workbook calculation had been flipped to manual....changed it to automatic and bam! My copy and paste of formulas worked. Thank you!