Excel copy and paste not working between workbooks

Keep in touch and stay productive with Teams and Officeeven when you're working remotely. You can move or copy a worksheet in the same workbook to organize your workbook exactly how you want.

Subscribe to RSS

You can use the Move or Copy Sheet command to move or copy entire worksheets also known as sheetsto other locations in the same or a different workbook. You can use the Cut and Copy commands to move or copy a portion of the data to other worksheets or workbooks.

Similarly, if you move a sheet that is referred to by 3-D references, the calculation might include or leave out data on the sheet. When you need to reorganize your data, you can easily change the order of sheets in a workbook, or move or copy a sheet to another workbook.

But be aware that calculations or charts that are based on sheet data may become inaccurate if you move the sheet. Drag the sheet tab to the location that you want the copied sheet to appear along the row of sheet tabs. On the Window menu, click the workbook that contains the sheet that you want to move.

On the To book menu, click the workbook that you want to move the sheet to. In the Before sheet box, click the sheet that you want to insert the moved sheet before, or click move to end. On the Window menu, click the workbook that contains the sheet that you want to copy. On the To book menu, click the workbook that you want to copy the sheet to.

In the Before sheet box, click the sheet that you want to insert the copied sheet before, or click move to end. Click Tab Colorand then click the color that you want to use.

excel copy and paste not working between workbooks

Rename a sheet. In Excel for the web, you can duplicate or copy worksheets within the current workbook. Simply right-click the tab name at the bottom of the sheet and click Duplicate. If you get an error, you can duplicate the sheet manually. If you have elements in your worksheet that interfere with duplicating it, you can still create a copy of the worksheet manually by copying all the data and pasting it into a new sheet.

excel copy and paste not working between workbooks

Here's how:. In Excel for the web, you can achieve the same result by copying all of the data in the worksheet and pasting it into a blank worksheet in the other workbook.

VBA Macro to Copy Data to Another Workbook

You can always ask an expert in the Excel Tech Communityget support in the Answers communityor suggest a new feature or improvement on Excel User Voice. Learn more. Intro to Excel. In this course: Create a new workbook Article Insert or delete a worksheet Article Move or copy worksheets or worksheet data Article Print a worksheet or workbook Article Use Excel as your calculator Article Fill data automatically in worksheet cells Article.

Move a sheet Drag the sheet tab to the location that you want along the row of sheet tabs. Here's how: Select all the data in the worksheet. Click the plus sign to add a new blank worksheet. Follow these steps to move or copy a worksheet to another workbook in Excel for the web: Select all the data in the worksheet.

Expand your Office skills. Get instant Excel help. Was this information helpful? Yes No.I have updated Windows and all Office apps to the latest version but that hasn't fixed the problem. I've also run the Office The symptom is very strange. When I hit Ctrl-C or use the drop-down menus on a cell in Excel the dashed lines that surround a cell selected for copying show up very briefly but immediately disappear.

If I go to another cell and paste it just puts a open parenthesis " " in the cell. Using Ctrl-X to cut exhibits similar behavior. If I repeatedly hit Ctrl-C it will occasionally work the dashed lines remain and I can paste but it typically takes tries before it will work and if I try again it will fail. This only seems to affect me when I try to copy cells. If I select a cell and then edit the cell and manually select the content of the cell I can copy and paste with no issue.

It also appears to only be an issue when a cell is not empty. If I select a cell that has been highlighted but has no content that also works properly. It's only when there's text or a formula in the cell that this is an issue.

View best response. Thanks for the suggestion, I didn't even know safe mode was an option for Excel. Unfortunately it looks like that isn't the issue. I tried starting in safe mode and the same problem exists.

Any other ideas? Thanks, I'm using a PC. Under the Home Ribbon, can you expand cell styles. Do you have something like this. Do you have something like this? Jan, it looks like here clipboard is not locked by any other program. Something is wrong within Excel. Correct, I don't think that's the case. I'm not getting an error that the clipboard is locked and the clipboard still functions correctly.

excel copy and paste not working between workbooks

Sorry for the delayed response, for some reason I didn't get a notification about another post so I just saw it when I came back and checked manually. It's definitely not a keyboard issue.

I have the same problem at home and at work and regardless of whether I'm using a docking station with external keyboard or built-in laptop keyboard. This function was working fine a couple of weeks ago, and now it is not. I am also noticing a latency in Excel across all files. Excel in Windows 10 slows down very frequently, even when only 1 workbook with no complex formulas is open.

I have the exact same problem on both my surface pro 4 and on my freshly formatted desktop pc. In ExcelI cannot copy any cells. The dashed lines will show briefly and then disappears. A copied cell usually have the dashed lines circling it all the time. When I try to paste, a left bracket shows up.Because of the limitations of web browser technology, copying and pasting text in Microsoft Office for the web differs from copying and pasting text in the Office desktop applications.

This article gives you steps for copying and pasting in each of the Office for the web programs. Word for the web. PowerPoint for the web. OneNote for the web. Excel for the web. Copy and paste behavior differs according to whether you are viewing, reviewing, or editing a Word document in the browser, and whether you are pasting content from outside Word for the web. When you open a document in Reading view, you can select text a line at a time by dragging the mouse not double-clicking.

You can paste the contents of the clipboard outside the document. When you do, the text is inserted into the new location without its formatting such as bold, italics, or a particular color. You can reapply these in the new location. To be able to select words or phrases, click Edit in browser.

If you want to paste within the document, click Edit in Browser. In Editing view you can cut, copy, and paste text and pictures within the document by selecting text or a picture just as you do in the Word desktop application. If you are using Firefox and you want to use the CopyCutand Paste commands on the Word for the web ribbon, you need to allow JavaScript to use the clipboard. On Chrome, you can install the Office - Enable Copy and Paste Extensionwhich will allows you to cut, copy, and paste with your mouse on all the Office Online apps.

Characteristics of the text, such as bold, italics, or a particular size or color, are preserved whenever possible. Depending on the source of your copied content, specific formatting aspects might not paste as expected. For paste text onlythe text and words are preserved, but the formatting will match the line of your document where you paste the content. Sometimes lists will paste with altered indentation. You can correct this by using the Numbering and Increase Indent buttons Home tab to achieve the desired result.

If you paste a link and it pastes as plain text, you can reconstruct the link by doing the following:. Leave text in the Display text box as it is, and then click Insert. Top of Page. You can cut, copy, and paste text within the presentation by selecting text just as you do in the PowerPoint desktop application.

You cannot copy or cut text in Reading view or Slide Show. To be able to copy or cut text, click Edit in browser. If you are using Firefox and you want to use the CopyCutand Paste commands on the PowerPoint for the web ribbon, you need to allow JavaScript to use the clipboard. Copy and paste behavior differs according to whether you are viewing or editing in the browser, and whether you are pasting text from outside Microsoft OneNote for the web. When you open a notebook in Reading view you can select text just as you do in the OneNote desktop application.

You can paste the contents of the clipboard outside the notebook. If you want to paste within the notebook, click Edit in Browser. In Editing view you can cut, copy, and paste text and pictures within the notebook by selecting text or picture just as you do in the OneNote desktop application. When you paste text from outside OneNote for the web the text is inserted into the notebook as plain text.

In other words, characteristics of the text, such as bold, italics, or a particular size or color, are not preserved and you must reapply them in OneNote for the web.By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service. The dark mode beta is finally here. Change your preferences any time.

Stack Overflow for Teams is a private, secure spot for you and your coworkers to find and share information. The following codes copies and pastes between different workbooks. I am not sure why it won't work without "Source. Activate" and "Master. Activate" lines? In other words, why is the activation of workbooks required despite the fact they were declared and set at the beginning?

For example:. You don't need the activates at all or anything to do with active workbook. But you do need to use match or find instead of looping through every cell in your master file. The Not IsErroris to skip the non matches, since Match throws an error when it doesn't find a match. The Match function returns the row number of the first match it finds. One other thing.

Worksheets Sheets. Count returns the last worksheet in the workbook, why not set this to a worksheet name like source is? Learn more. Asked 2 years, 5 months ago. Active 2 years, 5 months ago. Viewed 1k times. Count Source. Activate '??? For Each cell In Source. Columns "M". For Each cell2 In Master.

Columns "J". Offset 0, 9. Offset 0, Value cell2. Offset 0, 8. YowE3K Shouldn't need to. Are you saying it doesn't work without the Activate lines? That looks very cumbersome though - you are looping through a million million cells. Yes, it does not work without "Activate". What happens? An error?Please Note: This article is written for users of the following Microsoft Excel versions: 97, and If you are using a later version Excel or laterthis tip may not work for you.

For a version of this tip written specifically for later versions of Excel, click here: Can't Copy Data between Workbooks. Neil has Excel installed on several PCs in his office. On most of these he can copy data from one workbook to another workbook with no problems. 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. More than likely this has to do with how the two workbooks are opened on the problem machine.

If you open the workbooks in two different instances of Excel, then copying and pasting between instances is not the same as when the workbooks are opened in the same instance. 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 copying instead of the original formulas.

You cannot paste any attributes into a workbook in another instance of Excel

This is just one example; there are other pasting differences as well. The solution is to make sure that the workbooks are opened in the same instance of Excel. The easiest way to do this is to make sure that once the first workbook is open, you open the second workbook by using the Open tool on the toolbar or by choosing File Open.

If you instead use the Windows Start menu or a desktop icon to start Excel, you are opening a second instance of the program. If this doesn't solve the problem for you, then you should make sure that there is no macro running in the target workbook or worksheet when it is activated.

Look for code in the ThisWorkbook module and any other worksheet module in the target workbook's VBA project. 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.

You'll need to do some detective work to figure out if this is the case. ExcelTips is your source for cost-effective Microsoft Excel training. This tip applies to Microsoft Excel 97, and You can find a version of this tip for the ribbon interface of Excel Excel and later here: Can't Copy Data between Workbooks. With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author.

He is president of Sharon Parq Associatesa computer and publishing services company. Learn more about Allen Toolbars allow you to access common tasks quickly and easily. Excel provides a wide variety of toolbars, and you can even Word's Open dialog box provides many of the same file management functions as Windows Explorer does. One of the functions If you need to move the insertion point within your macro, then you'll want to note the HomeKey method, described in this Professional Development Guidance!

Four world-class developers offer start-to-finish guidance for building powerful, robust, and secure applications with Excel. The authors show how to consistently make the right design decisions and make the most of Excel's powerful features. Check out Professional Excel Development today! Want an easy way to insert a new row in a worksheet and copy everything from the row above?

You end up with two Copying formulas from one cell to another is quite intuitive in Excel—unless you want the copied formulas to follow Excel includes a handy shortcut for entering data that is similar to whatever you entered in the cell above your entry Enter your address and click "Subscribe. Your e-mail address is not shared with anyone, ever.

Maximum image size is 6Mpixels.Keep in touch and stay productive with Teams and Officeeven when you're working remotely. When you copy formulas to another location, you can choose formula-specific paste options in the destination cells.

Or, you can click the arrow next to the Paste button:. Clicking the arrow gives you a list of options. Here are the most commonly used ones:. Formulas — to paste just the formula and not the formatting of the original cell. Keep Source Formatting — to paste the formula, the number formatting, font, font size, border, and shading of the original cell. Paste Values — to exclude the formula and paste just the result. No Borders — to paste the formula, the number formatting, font, font size, shading--but not the border of the original.

Keep Source Column Widths — to paste the formula, the number formatting, font, font size, shading, border, and the width of the original. Transpose — Use this option when copying more than one cell.

If you copy cells that are side-by-side in a row, then this option will paste them in a column. If the cells are in a column, they'll be pasted into side-by-side in a row. This option pastes the formula, the number formatting, font, font size, shading, border. After copying a formula to a new location, it's important to check that its cell references are correct.

For example, if you copy a formula two cells down and to the right of cell A1, then the cells references you used will be updated like this:. Select the reference you want to change in the formula bar:. Press F4 to switch between the absolute and relative reference combinations, and pick the one you want.

For other formula paste options, click the arrow below Paste.

excel copy and paste not working between workbooks

You have many options here, but the most commonly used ones are:. Keep Source Formatting to paste the formula, the number formatting, font, font size, border, and shading of the original cell. The formula will be excluded. Learn more. Expand your Office skills. Get instant Excel help. Was this information helpful? Yes No. Any other feedback?Keep in touch and stay productive with Teams and Officeeven when you're working remotely.

Learn how to collaborate with Office Tech support scams are an industry-wide issue where scammers trick you into paying for unnecessary technical support services.

You can help protect yourself from scammers by verifying that the contact is a Microsoft Agent or Microsoft Employee and that the phone number is an official Microsoft global customer service number. Did this solve your problem?

Yes No. Sorry this didn't help. Could you upload the spreadsheet in one of this sites to be able to take a look and then post the url. I don't need real information uyou can change it. It will not allow me to paste the information at all. Thanks for your response and if you have any further suggestions, I am interested in hearing from you. April 14, Keep in touch and stay productive with Teams and Officeeven when you're working remotely.

Site Feedback. Tell us about your experience with our site. Within the same Excel workbook, I am unable to copy data and paste the information into another worksheet. Any suggestions on why this happens? I have multiple co-workers who are having the same issue. As a note,the file was created in Excel and is currently being updated using Excel This thread is locked.

You can follow the question or vote as helpful, but you cannot reply to this thread. I have the same question Previous Next. Volunteer Moderator. Hi, check the spreadsheet is not read only. Thanks for marking this as the answer. How satisfied are you with this reply? Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response? In reply to ediardp's post on May 24, It is not read only. I am restricted from all of theses sites, so unfortunately I cannot. THallsy Replied on June 1, I am having the exact same issue. Did you happen to figure it out? I tried copying and pasting from one worksheet to another in a new workbook both and formats and they worked fine.