Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 23rd 10, 04:42 PM
Junior Member
 
First recorded activity by ExcelBanter: Sep 2010
Posts: 1
Default cannot insert cells copied from one workbook to another

I used to be able to select rows in one workbook, press ctrl+C to copy them to the clipboard, select another open workbook by clicking on its tab in the taskbar, select the location to insert the copied rows by clicking on a cell in the far left column, then use the "insert cells" button in the Quick Access toolbar to insert the copied rows without overwriting existing rows.

About a month ago, I uninstalled and reinstalled MS Office 2007 on the same computer, running Windows 7, where I had been using it. I used the express installation as usual with no special options. Ever since then, I cannot insert copied cells between workbooks. The insert function will work within the same workbook, but not between different workbooks.

I can copy selected rows from one workbook to another by using copy and paste, but the copied cells will overwrite existing ones, so in order to avoid that, I must previously insert blank rows in the target workbook equal to the number of rows I am copying.

When I attempt to bring up the insert function, by using the Quick Access Toolbar button, by right-clicking, by using the insert command from the ribbon, or any other way, the target workbook does not show that there are any cells waiting to be copied. It will insert a blank cell or row instead.

This was not happening before I reinstalled the program. Any ideas?

  #2   Report Post  
Old September 23rd 10, 06:19 PM
Senior Member
 
First recorded activity by ExcelBanter: Aug 2010
Location: Philippines
Posts: 161
Default

Quote:
Originally Posted by XiGuaSiamese View Post
I used to be able to select rows in one workbook, press ctrl+C to copy them to the clipboard, select another open workbook by clicking on its tab in the taskbar, select the location to insert the copied rows by clicking on a cell in the far left column, then use the "insert cells" button in the Quick Access toolbar to insert the copied rows without overwriting existing rows.

About a month ago, I uninstalled and reinstalled MS Office 2007 on the same computer, running Windows 7, where I had been using it. I used the express installation as usual with no special options. Ever since then, I cannot insert copied cells between workbooks. The insert function will work within the same workbook, but not between different workbooks.

I can copy selected rows from one workbook to another by using copy and paste, but the copied cells will overwrite existing ones, so in order to avoid that, I must previously insert blank rows in the target workbook equal to the number of rows I am copying.

When I attempt to bring up the insert function, by using the Quick Access Toolbar button, by right-clicking, by using the insert command from the ribbon, or any other way, the target workbook does not show that there are any cells waiting to be copied. It will insert a blank cell or row instead.

This was not happening before I reinstalled the program. Any ideas?
Probably there are 2 instances of Excel application opened.

What do I mean? When you are opening the 2nd workbook, you should double click the file instead of opening another instance of MS Excel and then use the Open menu from there.
__________________
Asobi Wa Owari Da


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert copied cells Martin B Excel Worksheet Functions 3 August 30th 06 10:47 PM
Insert Copied Cells? HockeyFan Excel Discussion (Misc queries) 2 February 17th 06 02:32 PM
Excel - Insert Copied Cells jmrd Excel Discussion (Misc queries) 0 February 14th 06 10:52 PM
insert copied cells maryj Excel Discussion (Misc queries) 1 October 24th 05 07:56 PM
How can I get "Insert copied cells..." to not be grayed-out? toronto Excel Worksheet Functions 0 January 14th 05 08:59 PM


All times are GMT +1. The time now is 08:57 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017