Apparent Excel 2007 Copy & Paste Bug?

I've run into an Excel 2007 Copy & Paste problem that I thought I would
share with the group.

If you open an Excel 2003 (or earlier) workbook in Excel 2007 and that
workbook has data and formatting on one of its worksheets including having
some of its column widths set, and you then select all of the cells on the
worksheet and do a Copy and then switch to a brand new workbook and do a
Paste, the data and most of the formatting comes across OK.

However, the column widths may or may not be pasted depending on what kind
of workbook you are pasting into.

If you have told Excel that new workbooks are of type "Excel Workbook
(*.xlsx)" then the Paste will NOT bring along column widths.  If the new
workbook is of type "Excel 97 - 2003 Workbook (*.xls)" then it WILL.

The behavior seems to be that if both the source and target workbooks are
"compatible mode" or if they are both native mode then Copy and Paste bring
along column widths.  However when performing a mixed mode Copy and Paste
the column widths aren't copied.

This sure seems like a bug to me.  I just finished spending a couple of
hours trying to convince MS support that this was a problem but I don't
think I got anywhere.

What do the experts in this group think?

TIA,

josh 


0
Josh
4/25/2007 2:13:32 AM
excel 39879 articles. 2 followers. Follow

3 Replies
299 Views

Similar Articles

[PageSpeed] 22

>>This sure seems like a bug to me.

You may have run into a bit of a language barrier with MS.  To them a bug is 
something that does not work as designed.  They are saying I assume that 
this is the design.  You (and I) may think that the design is poor but that 
doesn't make it a bug.

I had some head banging experiences with them in betas until I got this. 
"You designed it to do that?!?", I would say. "Well, we considered situation 
A and situation B but we didn't consider situation C", (my case), "so by 
definition it's working as designed."

The workaround is easy though, Copy followed by Paste Special, Column 
Widths.

-- 
Jim
"Josh Sale" <jsale@tril dot cod> wrote in message 
news:%23zJib9thHHA.4596@TK2MSFTNGP05.phx.gbl...
| I've run into an Excel 2007 Copy & Paste problem that I thought I would
| share with the group.
|
| If you open an Excel 2003 (or earlier) workbook in Excel 2007 and that
| workbook has data and formatting on one of its worksheets including having
| some of its column widths set, and you then select all of the cells on the
| worksheet and do a Copy and then switch to a brand new workbook and do a
| Paste, the data and most of the formatting comes across OK.
|
| However, the column widths may or may not be pasted depending on what kind
| of workbook you are pasting into.
|
| If you have told Excel that new workbooks are of type "Excel Workbook
| (*.xlsx)" then the Paste will NOT bring along column widths.  If the new
| workbook is of type "Excel 97 - 2003 Workbook (*.xls)" then it WILL.
|
| The behavior seems to be that if both the source and target workbooks are
| "compatible mode" or if they are both native mode then Copy and Paste 
bring
| along column widths.  However when performing a mixed mode Copy and Paste
| the column widths aren't copied.
|
| This sure seems like a bug to me.  I just finished spending a couple of
| hours trying to convince MS support that this was a problem but I don't
| think I got anywhere.
|
| What do the experts in this group think?
|
| TIA,
|
| josh
|
| 


0
jrrech (1933)
4/25/2007 11:24:42 AM
The fact that they've made Copy and Paste work so inconsistently (i.e., 
depending on the mode of the source and target workbooks) in XL2007 and 
differently from previous versions (at least XL97, 2000, 2002 & 2003) makes 
me think its not really working as designed.

I also looked at the What's New in the online help and there is nothing 
there that would support this being an intentional change.

I agree that in general the workaround isn't that big a deal.  My problem is 
that I've got a bunch of macro's that perform these kinds of Copy and Paste 
operations and I'm not too excited about changing all of them to accomodate 
this "design change".  But obviously I will if I must.

Thanks,

josh




"Jim Rech" <jrrech@hotmail.com> wrote in message 
news:eyan$wyhHHA.3960@TK2MSFTNGP02.phx.gbl...
>>>This sure seems like a bug to me.
>
> You may have run into a bit of a language barrier with MS.  To them a bug 
> is
> something that does not work as designed.  They are saying I assume that
> this is the design.  You (and I) may think that the design is poor but 
> that
> doesn't make it a bug.
>
> I had some head banging experiences with them in betas until I got this.
> "You designed it to do that?!?", I would say. "Well, we considered 
> situation
> A and situation B but we didn't consider situation C", (my case), "so by
> definition it's working as designed."
>
> The workaround is easy though, Copy followed by Paste Special, Column
> Widths.
>
> -- 
> Jim
> "Josh Sale" <jsale@tril dot cod> wrote in message
> news:%23zJib9thHHA.4596@TK2MSFTNGP05.phx.gbl...
> | I've run into an Excel 2007 Copy & Paste problem that I thought I would
> | share with the group.
> |
> | If you open an Excel 2003 (or earlier) workbook in Excel 2007 and that
> | workbook has data and formatting on one of its worksheets including 
> having
> | some of its column widths set, and you then select all of the cells on 
> the
> | worksheet and do a Copy and then switch to a brand new workbook and do a
> | Paste, the data and most of the formatting comes across OK.
> |
> | However, the column widths may or may not be pasted depending on what 
> kind
> | of workbook you are pasting into.
> |
> | If you have told Excel that new workbooks are of type "Excel Workbook
> | (*.xlsx)" then the Paste will NOT bring along column widths.  If the new
> | workbook is of type "Excel 97 - 2003 Workbook (*.xls)" then it WILL.
> |
> | The behavior seems to be that if both the source and target workbooks 
> are
> | "compatible mode" or if they are both native mode then Copy and Paste
> bring
> | along column widths.  However when performing a mixed mode Copy and 
> Paste
> | the column widths aren't copied.
> |
> | This sure seems like a bug to me.  I just finished spending a couple of
> | hours trying to convince MS support that this was a problem but I don't
> | think I got anywhere.
> |
> | What do the experts in this group think?
> |
> | TIA,
> |
> | josh
> |
> |
>
> 


0
Josh
4/25/2007 1:56:28 PM
I found the same problem when I open Excel on 2 screens, when copying from one to the oter, the cell goes blank. I corrupts your whole document when you save it and try to open it later.

> On Tuesday, April 24, 2007 10:13 PM Josh Sale wrote:

> I've run into an Excel 2007 Copy & Paste problem that I thought I would
> share with the group.
> 
> If you open an Excel 2003 (or earlier) workbook in Excel 2007 and that
> workbook has data and formatting on one of its worksheets including having
> some of its column widths set, and you then select all of the cells on the
> worksheet and do a Copy and then switch to a brand new workbook and do a
> Paste, the data and most of the formatting comes across OK.
> 
> However, the column widths may or may not be pasted depending on what kind
> of workbook you are pasting into.
> 
> If you have told Excel that new workbooks are of type "Excel Workbook
> (*.xlsx)" then the Paste will NOT bring along column widths.  If the new
> workbook is of type "Excel 97 - 2003 Workbook (*.xls)" then it WILL.
> 
> The behavior seems to be that if both the source and target workbooks are
> "compatible mode" or if they are both native mode then Copy and Paste bring
> along column widths.  However when performing a mixed mode Copy and Paste
> the column widths aren't copied.
> 
> This sure seems like a bug to me.  I just finished spending a couple of
> hours trying to convince MS support that this was a problem but I don't
> think I got anywhere.
> 
> What do the experts in this group think?
> 
> TIA,
> 
> josh


>> On Wednesday, April 25, 2007 7:24 AM Jim Rech wrote:

>> You may have run into a bit of a language barrier with MS.  To them a bug is 
>> something that does not work as designed.  They are saying I assume that 
>> this is the design.  You (and I) may think that the design is poor but that 
>> doesn't make it a bug.
>> 
>> I had some head banging experiences with them in betas until I got this. 
>> "You designed it to do that?!?", I would say. "Well, we considered situation 
>> A and situation B but we didn't consider situation C", (my case), "so by 
>> definition it's working as designed."
>> 
>> The workaround is easy though, Copy followed by Paste Special, Column 
>> Widths.
>> 
>> -- 
>> Jim
>> "Josh Sale" <jsale@tril dot cod> wrote in message 
>> news:%23zJib9thHHA.4596@TK2MSFTNGP05.phx.gbl...
>> bring


>>> On Wednesday, April 25, 2007 9:56 AM Josh Sale wrote:

>>> The fact that they've made Copy and Paste work so inconsistently (i.e., 
>>> depending on the mode of the source and target workbooks) in XL2007 and 
>>> differently from previous versions (at least XL97, 2000, 2002 & 2003) makes 
>>> me think its not really working as designed.
>>> 
>>> I also looked at the What's New in the online help and there is nothing 
>>> there that would support this being an intentional change.
>>> 
>>> I agree that in general the workaround isn't that big a deal.  My problem is 
>>> that I've got a bunch of macro's that perform these kinds of Copy and Paste 
>>> operations and I'm not too excited about changing all of them to accomodate 
>>> this "design change".  But obviously I will if I must.
>>> 
>>> Thanks,
>>> 
>>> josh
>>> 
>>> 
>>> 
>>> 
>>> "Jim Rech" <jrrech@hotmail.com> wrote in message 
>>> news:eyan$wyhHHA.3960@TK2MSFTNGP02.phx.gbl...


>>> Submitted via EggHeadCafe 
>>> Visual Studio Async CTP Overview
>>> http://www.eggheadcafe.com/tutorials/aspnet/e78665f9-b949-4cc7-a024-654eb3bbad6d/visual-studio-async-ctp-overview.aspx
0
11/18/2010 7:20:36 AM
Reply:

Similar Artilces:

Looking for an excel function which can mirror opposite the data
Dear sir, There are 2 data sets is assumed running in A1 down, viz.: From A1 down to A10, are showing a set of number: from 1 to 10 In the cell from B1 to B10, are showing from 10 to 1, which is decreasing from 10 to 1. My question: I want to know is there any excel formula which I can place in B1 and pick A10's number; B2 pick A9's number and etc. I know there is an easy way to do it, just type "=A10" in the cell of B1, but it is quite difficult to do it when I have more than 200 number, e.g. A1 to A200. Thanks for your advice, Wilchong -- Message posted via OfficeKB...

Cannot print first cells on page 3 of Excel 2000 Spreadsheet.
I have a Excel spreadsheet with 6 pages, each page has a table with several columns and rows. When I go to print this spreadsheet, all the cells print except pages 3 and 5 and all the cells in the second row. Can somebody help? Thanks, --TJ All 6 pages on one worksheet? What is your print range defined as? Or do you mean 6 worksheets with a print range on each sheet? Gord Dibben MS Excel MVP On Thu, 13 Sep 2007 10:30:33 -0700, "techjohnny@gmail.com" <techjohnny@gmail.com> wrote: >I have a Excel spreadsheet with 6 pages, each page has a table with >several col...

Print a 2-sided document in Excel for a 3-ring binder?
How do I print a 2-sided document in Excel for a 3-ring binder? I have tried everything I can think of, but the margins on the backside are identical to the margins on the front and that doesn't work. The right margin on the back needs to be like the left margin on the front in order to punch holes in the document. Any help you can give would be great! I cannot be the only one who needs to know how to do this. Thank you! You would normally set that option on the printer functions, File>Print>click Properties next to printer name. "Mayableu" wrote: &...

excel -10 sections
I have a 10 section worksheet that I need to have a footer that says Section # page # on each page for printing the whole worksheet. eg Section 1 Page 10 would the page 10 of the whole worksheet: Section 3 Page 59 would be page 59 of the whole worksheet I've used a macro to do this in WORD, but haven't ever tried it in EXCEL. I'm guessing it would need a macro though. "Maggie" wrote: > I have a 10 section worksheet that I need to have a footer that says Section > # page # on each page for printing the whole worksheet. > eg Section 1 Page 10 would the pag...

How to make Access 2007 Navigation pane invisible?
I have tried the Access Options. | Current Database | Navigation, uncheck Display Navigation Pane, and the vertical "Navigation Pane" still displays in a compiled .ade. Something else yet? Dean Slindee "Dean Slindee" <slindee@charter.net> wrote in message news:%23o1Zj8odKHA.2188@TK2MSFTNGP04.phx.gbl... >I have tried the Access Options. | Current Database | Navigation, uncheck >Display Navigation Pane, and the vertical "Navigation Pane" still displays >in a compiled .ade. > > Something else yet? > > Dean Slinde...

copy with matched cases
Hi all; I would appreciate for any of your help! In my worksheet "Receiving", column A contains part names & column B contains quantities of each part that I receive and enter daily. e.g: A1=part1; A2=part11; A3=part200; B1=100; B2=200; B3=300 (entry on day 1). What should I do to achieve the followings once an assigned "Macro" button is activated: 1. In worksheet "Inventory", Column A remains unchanged that contains a list of 200 part names: where A1=part1; A11= part11; A200=part200. 2. Enter the date one column to the right to the previous date. Let say; C...

Analysis Cubes
What are the minimum requirements for using the Excel Addin for Analysis Cubes? Do you need to have GP installed to use the Excel AddIn? I have some users that need to access GP data, but I donot want to have to install GP on their Workstations, how do I do this? I am using GP version 8.0. See below for the requirements: 1. Supported Operating Systems: Windows 2000 Server; Windows 2000 Service Pack 2; Windows 2000 Service Pack 3; Windows 2000 Service Pack 4; Windows Server 2003; Windows XP; Windows XP Service Pack 1 2. To use the add-in with Analysis Services 2005, the following compone...

Writing to word 2007
I have a 2003 access database that writes data to text fields in a 2003 word document, no problems, I have now upgraded the database to 2007, and the same code although it appears to run ok, does not actually update the word document fields, i also tried converting the word document from 2003 to 2007. I data transfer using code from within access any thoughts? So no error message; it just doesn't seem top update, right. See this: http://support.microsoft.com/default.aspx/kb/242017 I do it with docvariables. Are you using docvariables? If so, read this: http://w...

Outlook 2007: "Cannot save free/busy information"
Hi, all I have been getting the error message "Cannot save free/busy information" from Outlook frequently these days. It started when we changed our configuration from connecting to an Exchange server on the LAN to using a proxy Exchange server that forwards (I imagine) to another Exchange server on a different LAN. I have my profile configured to deliver to a local PST file. It seems that Outlook does successfully update free/busy info on the server sometimes; the error message appears fairly randomly - e.g. sometimes when I delete a meeting request, but not every time. An...

excel #159
How do I prevent 2 files from opening up when I click on one file? What two files are opening? If it looks like: book1.xls:1 and book1.xls:2 Then you actually only have one workbook open--but you have two windows to that single workbook opening. Click on the window you don't want anymore and hit ctrl-w to close that window. Then save the workbook. ======== If that's not it, maybe you have another workbook in a folder named XLStart. Use windows start button and search for XLStart. Then look in each of those folders for a workbook file (*.xls). Move it or delete it if you'r...

Cannot open Money Deluxe 2007
New laptop, successfully using Money, then now I cannot open it. Windows keeps shutting it down. Tried running as admin. Tried uninstalling, then reinstalling. Help! -- Karen In microsoft.public.money, Karen wrote: >New laptop, successfully using Money, then now I cannot open it. Windows >keeps shutting it down. Tried running as admin. Tried uninstalling, then >reinstalling. Help! What OS? Is there an error message? Were you successfully using Money on that new laptop? Did the problem occur recently? You might want to consider a system restore point from before the pr...

Number of wsheets in an excel workbook???
hey guys, how many wsheets does one excel workbook have? I need to have about 66 - is that possible? Thanks. Maria -- mariasa ------------------------------------------------------------------------ mariasa's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31726 View this thread: http://www.excelforum.com/showthread.php?threadid=521656 Yes I have created a workbook with more sheets in it that that. obviously depending on the amount of data on each sheet your workbook could be getting quite large and possibly unmanageable! I guess you will have to try it! D...

copy date in a cell if within a date range
Column M is a listing of percentages Column A is various dates, anywhere from Jan 1, 1998 to the present. I need to copy the contents of let's say M3 into cell T3 is the date in cell A3 is any date in the year 2010. If the date is in another year, leave cell T3 blank Thanks "carrerapaolo" wrote: > Column M is a listing of percentages > > Column A is various dates, anywhere from Jan 1, 1998 to the present. > > I need to copy the contents of let's say M3 into cell T3 is the date in cell > A3 is any date in the year 2010. If the ...

moving text from a word document to excel
I'm moving a large amount of text from word documents to an excel spreedsheet, and I have a few questions: 1. When I copy/paste text from the document to the spreedsheet, the text will sometimes expand the cell very large. How can I keep all the cells the same size? 2. When I click on a cell that has text in it to read it, sometimes it will only show the text in a long downwards column, whereas other times it shows it as a big 'blurb' to the right side (which makes it easier to read). How can I set it up so it is not in a long column? 3. How can I insert cells without h...

Reporting Bugs to Microsoft
I have found a bug in Exchange 2003, does anyone know how I report this? Whats the bug? -- Mark Fugatt Microsoft Exchange MVP www.exchangetrainer.com www.msexchange.org "fatiefats" <anonymous@discussions.microsoft.com> wrote in message news:682EE703-4471-4D68-9359-CD32DD34DA9D@microsoft.com... >I have found a bug in Exchange 2003, does anyone know how I report this? I attempted to uninstall Exchange server. I need to do this because the domain controller was incorrectly installed. Anyway I am getting this message: Setup encountered an error while checking prereq...

memory problem of Excel 2003 copy & paste
Hi all, I am using Excel 2003 for some project. I am having 2GB C drive harddisk space. After a while, the Excel begins to be extremely slow in copy and paste... It takes about half an hour to copy and paste just a few cells... I've consulted people. It seems a memory problem. But I cannot close my windows and kill the processes, because I am running long-running (overnight) jobs... I cannot reboot either. Is there a way to clean the memory and let Excel 2003 clipboard function properly without rebooting or killing my 4 long-running processes? Thanks! p.s. I am sure this is an is...

in creating a pie chart in excel 2007
How many rows or columns of data can the pie chart plot I once tried 360 cells and got a wonderful Moiré pattern Why not just experiment with 1, 2, 3 dozen and see for yourself if the result is acceptable ? best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "bsalohcin" <bsalohcin@discussions.microsoft.com> wrote in message news:F9CF7752-1816-4DCE-BF82-9C25033AE888@microsoft.com... > How many rows or columns of data can the pie chart plot According to MS:- Data series in one chart 255 (max limit) Data points in a...

Excel-Multiple Cells Being Hi-lited
Sometimes when I'm setting up a worksheet and I left-click in a cell, multiple cells in the same column are hi-lited. After it happens the first time, it continues as I move through the worksheet, reducing my ability to get work done considerably. After some trial and error, it seems to occur when I've been adding and/or deleting columns and/or rows, after a header has been installed. I can move throughout the worksheet using the arrow keys, but it is a time consuming and cumbersome technique. I think the version I'm using is Office Professional 2007 (file extensi...

One Record Per Page Printing-Access 2007
Report for daily appointments for senior transportation drivers. Report is grouped by Driver. Keep together is selected. Detail band: Keep together-Yes; Force New Page-Before Section; Can Grow-Yes; Can Shrink-Yes Goal: Report generated so each driver has his/her own appointments. Orientation: Landscape, paper size 8.5 x 14, column width: 13.5729"; column height: 0.3069" When previewing in Print Preview one record per page is appearing rather than all appointments for a driver for a given date. I have the bands as narrow as I can make them. I am missing somethi...

where do office 2000 (including excel of course) service packs go
where do office 2000 (including excel of course) service packs go. I don't know why they don't give you the option of downloading and saving them before installing the various program updates and service packs. This way whenever I do a fresh reformat of my computer, i need to spend hours getting all the updates again off of the internet, where as if I could save thme, I would just have to re-install. Any help would be appreciated Don't know about Office 2000......never used it, but Office Download center offers you the choice of installing or saving to install file to disk....

How do I make a particular column required in Excel? #2
Our NPO is creating a reimbursement chart in Excel. We're trying to make it so that if employees do not fill in one particular column entitled "Projects," they will get an error or will be unable to have a final sum filled in. Is there any way I can make this particular column required so that if it is not filled in, the chart will not complete properly? Thank you in advance for any advice or help--I'm a bit of a novice to this! ...

Excel Events Conflict with VB and C# AddIns
Hi, I have two com addins running in Excel. One is written in VB and the other in C#. Both addins are interested in the Workbookopen event. When the event is triggered the c# code captures the event but the VB code does not. If i disable the c# addin then the vb code works. Looks like the c# addin is somehow blocking the vb events. Anyone know how to fix this? Many thanks, Andy There is only one WorkbookOpen event, so once one add-in hooks it, there is nothing for the other one to hook. If you are hooking the WorkbookOpen event in your add-ins, this is likely your problem. You may need...

cannot get BCM to work on Office Enterprise 2007 and Windows 7
I have Windows 7 and Office enterprise 2007 and tried to install BCM 2007 and got it installed then opened Outlook and said it could not setup database. Is BCM 2007 compatible with Enterprise and Windows 7. Is there a work around? ...

Refreshing pivot table when cut/paste data
I think this is supposed to be easy, but I'm having trouble. I have a pivot table that is run off data called Source. I need to replace the Source data on occasion, and so have been "cutting and pasting" the new data into Source - it's exactly the same in terms of columns, but has more rows. When I got to "refresh", the pivot table says it's invalid data, or some such error, and I have to rebuild. I think there is a way with links to do this, but I can't find it clearly explained. Any suggestions? Debra Dalgleish has some (lots) instructions here ...

Portrait only printing in Excel
I have an interesting problem. I have a workstation (Dell Pentium IV XP PRO) that has Office 2k on it. When I/we try to print to a networked printer, the document will only print in portrait no matter what changes I make to page settings or printer settings. We are on Active Directory, so as long as the documents are submitted from a different computer, it will print fine. Any suggestions? This could be a complete waste of your time, but the first thing I'd try is to reinstall the printer driver. (maybe even get a fresh driver from the printer manufacturer's web site???) Howa...