Can't Paste Without Issues

[Data123]

Hi I have a worksheet that I would like to copy a row from and paste it into another sheet with formulas within the same workbook. When I go to the developer area and click macros I do not see any macros listed, but I may have used one to create the row and then later deleted it. When I do try to paste the row it pastes with different values and formulas compared to the original. I can paste it as values only and it shows just fine. Why is this and how do I fix it please?

Process I have tried. I highlight 50 cells in one row. I use Ctrl-C, then go to a new cell in the same sheet, new sheet or a new workbook and press Ctrl-V. When I do this into a new cell regardless of where it gives me the #REF! in the first cell then #DIV/0 for the rest of the cells. If I highlight 50 cells and try to paste it into there I get the same error results. If I choose values only or links to paste the values are exactly the same as the original.

If a copy and paste the whole sheet into a new sheet it works perfectly.

The formulas in the row of interest do reference another sheet within the same workbook.

 

[Data123]

OK, great.
Is the same true when you click on each of the Sheet modules in that particular project?

Sorry for the delay. Yes the same is true no code.

 

[Joe4]

OK, so then there should not be any automated VBA code interfering with your Copy/Paste efforts.

 

[Data123]

Thank you. What else could cause Excel to prevent me to transpose the pasted row correctly? The formula i originally shared with you when transposed becomes this "=('Price Data'!C1-'Price Data'!C5)/'Price Data'!C5*100"

 

[Joe4]

It is very difficult to try to guess what might be going on without seeing your sheet structure, data, and formulas.
Is there any way you could upload a sample file (first removing any sensitive data) to a test sharing site, and provide the links to it here so we can download your file?
Then, lay out for us the exact steps you are doing that is causing this error to occur. Be sure to be detailed, including sheet names and range addresses!