The workbooks were old...likely created under an older version of Excel. It's just that when I copy something from Excel it cannot be pasted anywhere else except back again in EXCEL ? Help please! If you do find a macro there, then it could be that the macro is altering what is in the Clipboard or clearing it out entirely. http://haiteq.com/paste-not/copy-paste-not-working-in-excel-2003.php
Did you figure out the solution to your Excel problem with cutting and pasting? Mubariz Jafarov06 May 2016, 01:21 If Fnum > 0 ThenFor Fnum = LBound(MyFiles) To UBound(MyFiles)'open fileSet mybook = Workbooks.Open(MyPath & MyFiles(Fnum))With wsTotal'activate if you want (optional).Activate'.Cells.AutoFilter'copy all the data on the The time now is 02:41 AM. The data would appear in the right cells - 6 rows x 5 columns.Now I’ve started to use 2007 Excel.
Select A1:A5 and Copy the range.Select B1 and use Edit...PasteSpecial, click the Transpose option at the bottom of the dialog box.The data will be pasted into B1:F1, instead of B1:B5.As I Please help!!!With dual screens you can of course stretch the instance across both and then minimise the sheets-no need for two instances. I reloaded Excel at one point and that seemed to clear things up, but when I loaded a second workbook it repeated the non-copying behavior for the second....when I closed out Helpful Links ExcelTips FAQ ExcelTips Resources Ask an Excel Question Make a Comment Free Business Forms Free Calendars Tips.Net > Excel Home > Editing > Can't Copy Data between
The Excel program has been on the computer for a long time..perhaps it's corrupted in some fashion?Thanks, Bruce Post a reply Discussion is locked Flag Permalink You are posting a reply Also, you can check the link also: Excel 2010, CTRL-X only copies but does not cut http://answers.microsoft.com/en-us/office/forum/office_2010-excel/excel-2010-ctrl-x-only-copies-but-does-not-cut/000a6b2b-6d55-4469-8781-d7161f3bcec1 I quoted some infomation bellow: Two things that may have solved my problems (yes! Our Company Sharon Parq Associates, Inc. Trending Linux vs Windows? 11 answers What the hell is the matter with Microsoft ? 11 answers I don t understand what the difference is between Software and Operating system.
so in case you get rid of the inverted commas and enter the formula like =if(a1>3500,200,a hundred and fifty) then it is going to artwork with the conventional sum functionality yet On one of the PCs, although he can copy data from one worksheet to another worksheet in the same workbook, Neil cannot copy data to a different workbook. ENTER HERE © CBS Interactive Inc. / All Rights Reserved. https://support.microsoft.com/en-us/kb/2702629 Karl17 Aug 2015, 16:20 I encounter this error, "destination folder contains all kinds of 'names'" Wei Wang26 Mar 2015, 17:17 I had this problem.
The only way to copy was to open both sheets in the same instance of Excel. But, if you save a sheet while its sitting on the right screen and then try and open the file on a single monitor machine you'll be stuffed-windows tries to open If you open the two workbooks in different instances of Excel, then when you go to paste information into the target workbook, you get the results of whatever formulas you are Maruf29 Oct 2015, 05:29 Hii.
Share it with others Like this thread? http://www.computing.net/answers/office/microsoft-excel-copy-and-paste-problems/11036.html Please refer to our CNET Forums policies for details. Paste Special Greyed Out Flag Permalink Reply This was helpful (0) Collapse - Problem solved! Copy And Paste Not Working In Excel 2007 Thank you for helping us maintain CNET's great community.
Nveer seen it. ...just plain old cut and paste. More about the author It was being caused by Skype click to call, for some weird reason. Report • #11 paulplus_uk June 3, 2010 at 01:54:23 Hi GuysI tried the Copy using [Ctrl][C][C] but with no joy. To do this, simply copy a single cell to start with, instead of a range of cells. Excel Copy Paste Not Working Properly
But again, the macro manager says there are none. Thank you! Powered by vBulletin Version 4.2.3 Copyright © 2016 vBulletin Solutions, Inc. http://haiteq.com/paste-not/cut-copy-paste-not-working-excel.php If so, your add-in appears to be the culprit.
Interesting theory. Such opinions may not be accurate and they are to be used at your own risk. Please advise if you know what has caused this issue and how to correct.
I suspect it is some options in Excel, but not sure what it is. LinkBack LinkBack URL About LinkBacks Bookmark & Share Digg this Thread!Add Thread to del.icio.usBookmark in TechnoratiTweet this thread Thread Tools Show Printable Version Display Linear Mode Switch to Hybrid Mode I cannot cut and paste formulas or copy worksheets as I did in the past. The sheets are related to income tax so there will be plenty of opportunity for the problem to reoccur in the next few weeks.Bruce Flag Permalink Reply This was helpful (1)
I finally had to view hidden files, and "View Protected Operating System Files" with a lot of DON'T DO THAT WARNINGS, but that was the only was to delete the file.At It should paste tab-delimited now. Select the option Values from this dialog box and click OK.The image on the right below shows the result of the Paste Special. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Feb 1st, 2011,03:44 PM #9 Gary McMaster Board Regular Join Date Feb 2009 Location Massachusetts, USA Posts 1,972 Re:
are in an .xslm workbook. I also have Skype so maybe have that Skype Plug-in problem but have no idea how to find out...!!!I use spreadsheets on a daily basis with formulas and I have been Update: guys, I cannot paste it anywhere, it's just a simple text, i cannot paste it into notepad and into ms word as well, the only place i can paste is Register Help Remember Me?
More questions A Problem in MS Excel!? You can do this using the Excel 'Paste Special' command, which is found in the menu that appears when you right click the mouse.The 'Paste Special' command can also be accessed For example, you can copy / paste from excel to word. When I copied and pasted, I would get the results of the formula as it/they existed in the original cell(s) rather than the formula(s).
Its working for me. :o) Erika · 5 days ago 0 Thumbs up 0 Thumbs down Comment Add a comment Submit · just now Report Abuse Add your answer I have Reply With Quote Feb 14th, 2010,04:13 PM #3 mussermike New Member Join Date Jun 2009 Posts 19 Re: Lost the "right click" cut/copy/paste Thank you, worked like a charm!