LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
WL WL is offline
external usenet poster
 
Posts: 3
Default Adding more than 65,536 rows in Excel 2007

When I try to cut and insert 20,000 rows from one worksheet to another
worksheet that already has 50,000 rows I get the error "To prevent possible
loss of data, Excel cannot shift nonblank cells off of the worksheet." I
only see a total 65,536 rows in the worksheet - I thought Excel 2007
supported a million rows.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding Error Bars Excel 2007 Lars B Excel Discussion (Misc queries) 8 January 27th 09 11:55 AM
Adding new rows to an Excel spreadsheet niletrader Charts and Charting in Excel 0 October 21st 07 10:51 PM
Excel 2007 - Adding Labels to Scattergraph Points RFJ Charts and Charting in Excel 2 April 25th 07 04:46 PM
How do I view the maximum rows in Excel 2007 (Million Rows)? shanth Excel Discussion (Misc queries) 2 January 15th 07 05:45 PM
adding rows to excel table haystack New Users to Excel 4 April 25th 06 01:45 PM


All times are GMT +1. The time now is 06:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"