Excel 2010 Preview #2: Copy & Paste Special Magic

Hi all,

This had me scratching my head: at work, we're using a large-ish .xlsx file, with about 20K rows, with a lot of look-ups and so on. A messy job, but it's being kept in use due to, well, user reluctance to switch to an Access solution. You know the drill.

There is a manual operation where cells from one tab are copied and then Paste/Special/Values into another tab of the same workbook. There are three columns and about 20 thousand rows involved.

Until recently, we were using Excel 2007 and, on a stock PC, it took about 10-15 seconds for the paste operation to complete. Automatic recalculation is turned off, as there is a LOT of VLOOKUPs -- about 25 columns times 20 thousand rows.

Anyway, since our company upgraded to Excel 2010, the same paste operation now takes anywhere between 40 and 60 MINUTES. Automatic calculation is still turned off. I have no clue why is this happening. The same file, on a slower machine (2-year old HP Mini) under Excel 2007, performs the same operation in about 10 seconds.

Any clues? I am truly lost for ideas.

Cheers!

When copying from one workbook to anather, the day date is one day later and
the year is four years later. Is there some way to fix this?

We have a number of Excel users in our office who cannot copy and paste
between Excel workbooks. They can copy and paste between worksheets. When
you highlight the section to copy and then go to the new workbook both the
paste
and paste special are "grayed out". This is true whether you right-click the
mouse, go to the edit menu, or use control keys. This occurs with any data
type and the most simple workbooks. I have seen some suggestions here but
none have worked for this particular problem. I have reset the menus and
renamed the .xlb files and neither helps. You can open the clipboard and the
paste will work, but there is no paste special option. Any help would be
greatly appreciated. Thanks!

Hello,

I am using Excel 2010 Professional (v 14.0.5128.5000 32-bit) and ran into what seems to me like a bug...

I have put together a large spreadsheet of systems and network devices along with columns containing various properties. I have been working on filling in the various properties and to help select the right rows, I have been using the "Filter" function. I use the filter to drill down to the rows containing the column I want to modify-- which will contain the exact same value for all rows selected. Then I edit the value of one row/column, then select it, copy it, and then drag-select all of the remaining rows and do a paste-value.

That should be it... except it isn't, ALL of the rows *inbetween* the filtered rows, ALSO get updated with that value, as if they had not been filtered at all !!! The only rows that do NOT get updated are the rows which lie ENTIRELY OUTSIDE the filtered range.

If this is not a bug but instead a "feature"-- someone please clue me in as to its supposed purpose ! :-)

Thanks,



John Whitten

I know this is the 2007 forum, but I didn't see a 2010 forum, I can't tell which actual version is in the 2010 Office Suite, and the 2008 forum looks pretty dead.

Anyway, I'm feeling more dumber today because Excel tells me it can't paste a formula, any formula, even SUM(), into a new document. I have never experienced this before so I'm assuming it is because I am copying from a 2003 document into a 2010 document.

Is there any way to fix this? I have some HUGE spreadsheets that I need to copy into new files and this is going to send me right back to 2003 if I can't find some workaround.

Thanks!

Hi,

I am completely new to excel programming. I have a SQL DTS which
creates an excel file and exports data into it. The created excel file
could have variable number of work sheets.

Text data in the excel file had a leading single quote character and
spaces before the data. I can get rid of these by copying entire sheet
and paste special--values into a new sheet.

Would some one tell me how to automate to create a new excel file and
copy and paste special (with values option) all the work sheets into
the new file? I appreciate any help.

Hello,

I have written a short macros, which copy data range from Excel and paste it special as Enhanced Metafile in table cell in Word file.
The problem is that picture pasted is much larger than cell. But I need it fit the cell (cell size is fixed).
Maybe anybody had the same kind of a problem and can give an advice?

I used the code below. Maybe any is missing?

Selection.PasteSpecial Link:=False, DataType:=wdPasteEnhancedMetafile, Placement:=wdInLine, DisplayAsIcon:=False

Or give an advice how to resize pasted object.
Thanx a lot in advance!

Does anyone know of a way to replace 'Copy-Paste' with 'Copy- Paste Special -Paste Values'?

Ideally, 'Copy-Paste' shoud be disabled and 'Copy- Paste Special -Paste Values' would be the default option.

Is this even do-able?

Any ideas?

I have an xls file. I open up in Excel 2007, the print preview looks fine: margin looks right
But when I open the same file in Excel 2010, the print preview doesn't look right.
It's like everything gets shifted to the left and has the wide margin on the right hand side.

Anybody knows what's causing the problem in 2010?

Thanks in advance.