I've been using the clipboard on excel for about the past 6 years every two weeks. Just recently, something has been going wrong and I am not able to use the clipboard the same way anymore and now it is very time consuming. w
I change a few things but to keep it simple this is an example of what's going on.
http://i.imgur.com/TbC66fO.jpg
As you can see, I update the dates and I input new data. I copy the dates so that when I have to update another customers spreadsheet I already have the dates so I can just install it. This is what it's supposed to look like when I paste all of the stuff from the clipboard. The problem is that lately the format of pasting the cells are coming off as very wrong and I do not know why.
When I paste from the clipboard, this is what it's doing now.
http://i.imgur.com/JDilBCD.jpg
As you can see, the H column is wider making me end up printing a second page, the date changes from 17 to 2017, and the dates also change format. When before everything was pasting exactly as is in the clipboard. I believe this must be a problem with excel somewhere because it does the same on a different computer that i had tried. Also, paste special doesn't always work.
If you guys have any solutions, ideas, let me know because I'm really stuck here. I know I can do paste special but I paste many times and its just more efficient to have it the way it was. Also, let me know how it works for you guys. Maybe I just have to uninstall everything if it's working fine on your end.right now I have office 2016.
edit: I just want to paste and it'll look just like what is being pasted instead of coming out like this;
http://i.imgur.com/E5Js2ma.jpg
Bookmarks