I am trying to paste a group of cells from one excel book that gets information from two other books. For the past...forever...when I paste into the last book, I right click the cell and paste special and got several options to choose from, the paste with values is the one I am after.
Now, for a reason I am sure is my fault, when I paste special, I get two options;
Paste:
Paste link:
I don't want those options. I want the option list that gives me the option of pasting special with values. Anyone have an idea of what I could have done wrong to make the values option screen go away.
Thank you
Bookmarks