URGENT: #REF! ERROR WHEN COPY AND PASTED
DEAR ALL
Pls help me. I am reposting this as got no response. I was counting on Dave, Tom, Chip and Bob to help me out. It is excel 1997. I have one range in a sheet referring to cells from another sheet. I used to copy and paste to access the values from the other sheet. Suddenly now if I copy and paste I am getting #REF! error. Pls enlighten me as to what could be the reason. I will be eagerly waiting as I am not able to do lots of calculations bcos of this problem. |
URGENT: #REF! ERROR WHEN COPY AND PASTED
"CAPTGNVR" wrote...
Pls help me. I am reposting this as got no response. I was counting on Dave, Tom, Chip and Bob to help me out. It is excel 1997. I have one range in a sheet referring to cells from another sheet. I used to copy and paste to access the values from the other sheet. Suddenly now if I copy and paste I am getting #REF! error. Pls enlighten me as to what could be the reason. I will be eagerly waiting as I am not able to do lots of calculations bcos of this problem. Do you mean you're getting #REF! errors in the pasted range? Or in some other range referring to the pasted range? Or to yet another range referring to the original range that you copied? If the first, what are the formulas in the original range copied and the destination range pasted? Note: if cell G3 contained the formula =C3, and you copy G3 and paste into D7, the formula becomes =#REF! because there's no 4th column to the left of column D. |
URGENT: #REF! ERROR WHEN COPY AND PASTED
On Jul 16, 3:34 pm, "Harlan Grove" wrote:
"CAPTGNVR" wrote... Pls help me. I am reposting this as got no response. I was counting on Dave, Tom, Chip and Bob to help me out. It is excel 1997. I have one range in a sheet referring to cells from another sheet. I used to copy and paste to access the values from the other sheet. Suddenly now if I copy and paste I am getting #REF! error. Pls enlighten me as to what could be the reason. I will be eagerly waiting as I am not able to do lots of calculations bcos of this problem. Do you mean you're getting #REF! errors in the pasted range? Or in some other range referring to the pasted range? Or to yet another range referring to the original range that you copied? If the first, what are the formulas in the original range copied and the destination range pasted? Note: if cell G3 contained the formula =C3, and you copy G3 and paste into D7, the formula becomes =#REF! because there's no 4th column to the left of column D. D/HARLAN Thanks ur response. I have the below formulas for example in one sheet in col-AA =IF(PAWY_INPUT!G4="","",PAWY_INPUT!G4) =IF(PAWY_INPUT!G5="","",PAWY_INPUT!G5) I used to copy and paste it in say col -B of the same sheet and it was working fine. I was doing lots of changes and dont know what happened -- now when i copy and paste it in col-B i get this #REF!. In a new workboom it works fine. But i hv gone too deep in this workbook to ignore this. pls adv |
URGENT: #REF! ERROR WHEN COPY AND PASTED
On Jul 16, 3:45 pm, CAPTGNVR wrote:
On Jul 16, 3:34 pm, "Harlan Grove" wrote: "CAPTGNVR" wrote... Pls help me. I am reposting this as got no response. I was counting on Dave, Tom, Chip and Bob to help me out. It is excel 1997. I have one range in a sheet referring to cells from another sheet. I used to copy and paste to access the values from the other sheet. Suddenly now if I copy and paste I am getting #REF! error. Pls enlighten me as to what could be the reason. I will be eagerly waiting as I am not able to do lots of calculations bcos of this problem. Do you mean you're getting #REF! errors in the pasted range? Or in some other range referring to the pasted range? Or to yet another range referring to the original range that you copied? If the first, what are the formulas in the original range copied and the destination range pasted? Note: if cell G3 contained the formula =C3, and you copy G3 and paste into D7, the formula becomes =#REF! because there's no 4th column to the left of column D. D/HARLAN Thanks ur response. I have the below formulas for example in one sheet in col-AA =IF(PAWY_INPUT!G4="","",PAWY_INPUT!G4) =IF(PAWY_INPUT!G5="","",PAWY_INPUT!G5) I used to copy and paste it in say col -B of the same sheet and it was working fine. I was doing lots of changes and dont know what happened -- now when i copy and paste it in col-B i get this #REF!. In a new workboom it works fine. But i hv gone too deep in this workbook to ignore this. pls adv D/HARLAN wow. Real valid info u gave me. U guided me well. I changed the cell to absolute ref like =IF(PAWY_INPUT!$G$6="","",PAWY_INPUT!$G$6) and then when i copy and paste it works. Now at least again I am proceeding with the further calculations. |
All times are GMT +1. The time now is 02:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com