| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 Selection too large
I am copying a row which is 208 columns wide (though not all of those columns
are in use). Excel 2007 will only let me copy this down across about 10 rows at a time without aborting the operation with a "Selection too large" message. Using the same model, I have regularly copied this data across 500 rows in Excel 2003 with no problems. It is very frustrating as it takes some 50 operations to complete the copying. Is this a new restriction in 2007 or have I missed a set up option? -- Paul |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2007 Selection too large
Perhaps it's a bug. Recall that XL 2007 is currently in beta mode.
Dave -- Brevity is the soul of wit. "PaulW" wrote: I am copying a row which is 208 columns wide (though not all of those columns are in use). Excel 2007 will only let me copy this down across about 10 rows at a time without aborting the operation with a "Selection too large" message. Using the same model, I have regularly copied this data across 500 rows in Excel 2003 with no problems. It is very frustrating as it takes some 50 operations to complete the copying. Is this a new restriction in 2007 or have I missed a set up option? -- Paul |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2007 Selection too large
Dave,
My thoughts as well. I'm reluctant to immediately label things as a bug in case there is a good (but well disguised) reason! I was also slightly surprised that no one else seems to have hit this issue as it is not an uncommon procedure so am curious to know whether it just my installation or have others found the same? Hopefully, the developers will pick this point up from this forum. -- Paul "Dave F" wrote: Perhaps it's a bug. Recall that XL 2007 is currently in beta mode. Dave -- Brevity is the soul of wit. "PaulW" wrote: I am copying a row which is 208 columns wide (though not all of those columns are in use). Excel 2007 will only let me copy this down across about 10 rows at a time without aborting the operation with a "Selection too large" message. Using the same model, I have regularly copied this data across 500 rows in Excel 2003 with no problems. It is very frustrating as it takes some 50 operations to complete the copying. Is this a new restriction in 2007 or have I missed a set up option? -- Paul |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2007 Selection too large
Well, I haven't noticed this particular issue when I've used XL 2007.
Prehaps you should contac the Excel 2007 developers directly at their blog: http://blogs.msdn.com/excel/ I have contacted them before about other issues and they have been responsive. Dave -- Brevity is the soul of wit. "PaulW" wrote: Dave, My thoughts as well. I'm reluctant to immediately label things as a bug in case there is a good (but well disguised) reason! I was also slightly surprised that no one else seems to have hit this issue as it is not an uncommon procedure so am curious to know whether it just my installation or have others found the same? Hopefully, the developers will pick this point up from this forum. -- Paul "Dave F" wrote: Perhaps it's a bug. Recall that XL 2007 is currently in beta mode. Dave -- Brevity is the soul of wit. "PaulW" wrote: I am copying a row which is 208 columns wide (though not all of those columns are in use). Excel 2007 will only let me copy this down across about 10 rows at a time without aborting the operation with a "Selection too large" message. Using the same model, I have regularly copied this data across 500 rows in Excel 2003 with no problems. It is very frustrating as it takes some 50 operations to complete the copying. Is this a new restriction in 2007 or have I missed a set up option? -- Paul |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2007 Selection too large
Dave ,
Thanks for the link. -- Paul "Dave F" wrote: Well, I haven't noticed this particular issue when I've used XL 2007. Prehaps you should contac the Excel 2007 developers directly at their blog: http://blogs.msdn.com/excel/ I have contacted them before about other issues and they have been responsive. Dave -- Brevity is the soul of wit. "PaulW" wrote: Dave, My thoughts as well. I'm reluctant to immediately label things as a bug in case there is a good (but well disguised) reason! I was also slightly surprised that no one else seems to have hit this issue as it is not an uncommon procedure so am curious to know whether it just my installation or have others found the same? Hopefully, the developers will pick this point up from this forum. -- Paul "Dave F" wrote: Perhaps it's a bug. Recall that XL 2007 is currently in beta mode. Dave -- Brevity is the soul of wit. "PaulW" wrote: I am copying a row which is 208 columns wide (though not all of those columns are in use). Excel 2007 will only let me copy this down across about 10 rows at a time without aborting the operation with a "Selection too large" message. Using the same model, I have regularly copied this data across 500 rows in Excel 2003 with no problems. It is very frustrating as it takes some 50 operations to complete the copying. Is this a new restriction in 2007 or have I missed a set up option? -- Paul |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2007 Selection too large
Very prompt response from David Gainer. He has confirmed there is no issue in
later builds of XL2007. So good news. -- Paul "Dave F" wrote: Well, I haven't noticed this particular issue when I've used XL 2007. Prehaps you should contac the Excel 2007 developers directly at their blog: http://blogs.msdn.com/excel/ I have contacted them before about other issues and they have been responsive. Dave -- Brevity is the soul of wit. "PaulW" wrote: Dave, My thoughts as well. I'm reluctant to immediately label things as a bug in case there is a good (but well disguised) reason! I was also slightly surprised that no one else seems to have hit this issue as it is not an uncommon procedure so am curious to know whether it just my installation or have others found the same? Hopefully, the developers will pick this point up from this forum. -- Paul "Dave F" wrote: Perhaps it's a bug. Recall that XL 2007 is currently in beta mode. Dave -- Brevity is the soul of wit. "PaulW" wrote: I am copying a row which is 208 columns wide (though not all of those columns are in use). Excel 2007 will only let me copy this down across about 10 rows at a time without aborting the operation with a "Selection too large" message. Using the same model, I have regularly copied this data across 500 rows in Excel 2003 with no problems. It is very frustrating as it takes some 50 operations to complete the copying. Is this a new restriction in 2007 or have I missed a set up option? -- Paul |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Excel 2007 Beta 2 chart problems | Charts and Charting in Excel | |||
| Excel 2007 Beta Advanced Filter Performance | Excel Discussion (Misc queries) | |||
| Another Filtering Question for Excel 2007 Experts | New Users to Excel | |||
| Linking Large Access Table into Excel | Links and Linking in Excel | |||
Linear Mode
