I have used excel for 20 years. I am not an expert, but when the copy/paste function is not working properly, I am frustrated. Here's what is happening. In cell A I put a formula combining other cells. When I try to copy cell A to cell B, the correct revised formula appears in the box, but what is copied is the value in cell A. I have not instructed it to copy to value, have just used the plain old copy/paste by right-clicking the mouse.
Am I crazy? Anyone ever experience this?
Hi a3b2m2Bb and welcome to the forum,
This sounds like you need to study relative vs absolute addressing in a formula in Excel. It all comes down to the dollar signs in the address.
See:
http://www.cpearson.com/excel/relative.aspx or
http://web.pdx.edu/~stipakb/CellRefs.htm
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Thanks, I do need to do that. Turns out in this case that, for some reason, the function "calculate" was on manual, not automatic. That seems to have fixed it. I have never fooled with that function, so don't know how it happened.
Glad you found the calculate modes. That should do it. Can you change the prefix of the original post to "Solved" so others will know you have found an answer?
Good idea. Should I post another message asking "how?"
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks