Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default To many rows in worksheet in 2007

I have the max number of rows showing up every time I open a workbook or add
a sheet. How do I get my sheets to go back to 60,000 rows? I tried to
delete them but they don't go away, I've tried to set up a template with
60,000 rows but when I open it up I have the million rows back. Having a
million rows takes up to much time when opening, saving, etc.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 118
Default To many rows in worksheet in 2007

Hi Zoolady

In fact the opposite is true. 2007 with it's 'million' rows opens faster and
takes up less space on the disk than previous versions of Excel.

Slow opening is usually due to some fancy links in your spreadsheet. Check
Data -- Edit links and make sure all your links refer to valid paths.

If this helps, please click "Yes"
<<<<<<<<<<<


"zoolady" wrote:

I have the max number of rows showing up every time I open a workbook or add
a sheet. How do I get my sheets to go back to 60,000 rows? I tried to
delete them but they don't go away, I've tried to set up a template with
60,000 rows but when I open it up I have the million rows back. Having a
million rows takes up to much time when opening, saving, etc.

Reply
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
How do I get my Excel 2007 worksheet to go beyond 65536 rows? Alan Excel Worksheet Functions 1 May 4th 09 04:03 PM
Copy rows from one worksheet automatically, ignore rows that are b Kris Excel Worksheet Functions 2 October 10th 08 09:28 PM
Import an MS Money 2007 file into MS Excel 2007 worksheet DonF Excel Discussion (Misc queries) 0 August 29th 08 11:14 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
How do I insert blank rows between rows in completed worksheet? bblue1978 Excel Discussion (Misc queries) 1 October 26th 06 07:02 PM


All times are GMT +1. The time now is 11:09 AM.

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

About Us

"It's about Microsoft Excel"