I am having something annoying as fuck happen in Excel... it wont let me copy one tab over to another file... says there arent enough columns in the second file... wtf?

8/1/2009 4:29:08 PM

try selecting all and just copy/pasting the contents instead of the whole sheet.

and how f'in many columns are in that sheet? lol

8/1/2009 5:34:00 PM

but I dont want to do that, you have to redo the column spacing and other shit... its only 7 columns... no idea why its saying it

8/1/2009 6:06:46 PM

if it's only 7 columns then how the hell is it too difficult to redo the spacing? wtf

8/1/2009 6:19:37 PM

because its going to have to be done numerous times

8/2/2009 7:39:53 PM

are you trying to copy an excel tab from the new Excel 2007 format into the older format?

8/2/2009 9:23:26 PM

nope

8/3/2009 1:28:21 AM

What version of Excel and exactly what error message are you getting? Do you have any Add-ons enabled?

8/3/2009 9:08:19 AM

How are you trying to copy exactly?

I've had excel complain about not enough columns if i did the following:
* highlight all of sheet 1 (either with ctrl+A[x2] or by clicking the top left corner that selects all columns and rows)
* with all of sheet 1 highlighted press ctrl+C
* switch to sheet 2
* cursor is not in A1 (could be in A2, or B1... basically anywhere but A1)
* press ctrl+v to paste
* Excel complains about not enough columns.

Solution: Move cursor to A1 and paste, OR go back to sheet 1 and select only the columns or cells i want to copy and paste them into sheet 2.

8/3/2009 1:27:12 PM

right clicking on the tab, then "move or copy", select the other file, change it to "make a copy", move to end

8/3/2009 2:17:39 PM

^ correct.

o, realized you were OP... not sure why it's not working then.

[Edited on August 4, 2009 at 11:30 AM. Reason : af]

8/4/2009 11:29:03 AM

Speaking of copying in excel...anyone know the number of cells you can copy and paste in Excel 2007?

I'm trying to copy about 980k cells but the clipboard is giving me an error that says "Item Not Collected: Large than clipboard capacity"

10/21/2009 11:47:27 AM

lol you might wanna split that one down to 100K or so

[Edited on October 21, 2009 at 11:51 AM. Reason : or use a database..jesus. ]

10/21/2009 11:51:48 AM

10/21/2009 12:38:26 PM

Microsoft really goofed by expanding the number of available rows in a sheet.

Data over a few thousand rows should really be handled in a database. 980K rows in Excel is crazy.

10/21/2009 12:55:02 PM

^One more instance of: Just because you can, doesn't mean you should.

10/21/2009 1:05:19 PM

yeh, I've got a few that are 500k +. It's a pain to work in them

10/21/2009 1:40:12 PM

Quote :

"Microsoft really goofed by expanding the number of available rows in a sheet. Data over a few thousand rows should really be handled in a database. 980K rows in Excel is crazy."

It's not 980k rows, it's 980k cells. It's about 31k rows by 28 columns.

10/21/2009 2:16:41 PM