Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
large file - copy and paste small group
I am working with a spreadsheet totaling 200,000 items. I am trying to copy
and paste 26,000 visible rows. Keep getting "too complex". I've tried Move and copy entire cell directions and Copy visible cells only directions. Still get the message. Any suggestions? Otherwise I will have to select smaller versions of the 26,000 to get the job done. Shouldn't have to do that. -- Chel294 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
large file - copy and paste small group
Hi,
The problem is not the number of rows but the number of non-contiguous rows. If you can temporarily sort the data to bring the visible cells to the top then the copy will work. We don't know enough about your data to make better suggestions. What does it look like, how is it grouped, meaning on what criteria? Is there a common feature in one column that would indicate that row will be visible? -- If this helps, please click the Yes button. Cheers, Shane Devenshire "CHEL294" wrote: I am working with a spreadsheet totaling 200,000 items. I am trying to copy and paste 26,000 visible rows. Keep getting "too complex". I've tried Move and copy entire cell directions and Copy visible cells only directions. Still get the message. Any suggestions? Otherwise I will have to select smaller versions of the 26,000 to get the job done. Shouldn't have to do that. -- Chel294 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
large file - copy and paste small group
Shane,
Thank you very much for your explanation. Let me see if I can explain this file. The file is part number specific, the multiple attributes that go with that part are something like 70 columns wide. I could sort by any particular attribute to get to a smaller version. Not all versions could be sorted smallest to largest or alphabetically. So, getting the 26,000 items to the top is going to be next to impossible. What I find interesting about Excel 2007, is we have the ability to get more lines on a spreadsheet, but difficult to impossible to manipulate. I could do this function all day long in Excel 95 (with 65,000 line items). It didn't matter if the selection was non-continguous. Do I sound frustrated? I am. -- Chel294 "CHEL294" wrote: I am working with a spreadsheet totaling 200,000 items. I am trying to copy and paste 26,000 visible rows. Keep getting "too complex". I've tried Move and copy entire cell directions and Copy visible cells only directions. Still get the message. Any suggestions? Otherwise I will have to select smaller versions of the 26,000 to get the job done. Shouldn't have to do that. -- Chel294 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What causes inordinately large file sizes for small spreadsheets? | Excel Discussion (Misc queries) | |||
How do I break a large .CSV file into several small Excel files? | Excel Worksheet Functions | |||
HOW DO I COPY & PASTE A SMALL INFO FM AN XL TO THE CELL COMMENT | Excel Worksheet Functions | |||
Office 2000-Small Business, XCEL eror = copy/paste error | Excel Discussion (Misc queries) | |||
vba to sort group copy paste to another sheet | Excel Worksheet Functions |