Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
How can I see more than 65,536 rows in Excel 2007?
Everytime I open Excel 2007 I only see 65,536 rows and before I have everyone
on my team upgrade to Excel 2007 I need to make sure that it can go up to 1 million rows. Do I have to install an add-in to get the extra lines? |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
How can I see more than 65,536 rows in Excel 2007?
This happens when you start a new workbook?
If yes, then I bet you have a template file (*.xlt) that was saved as an xl2003 (or below) file. Try deleting (or moving) that book.xlt file (use Windows|Search to find it) TraceyGMEC wrote: Everytime I open Excel 2007 I only see 65,536 rows and before I have everyone on my team upgrade to Excel 2007 I need to make sure that it can go up to 1 million rows. Do I have to install an add-in to get the extra lines? -- Dave Peterson |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
How can I see more than 65,536 rows in Excel 2007?
That worked! My IT group changed the option to save it as Excel 2003 since
most of the company is still on Office 2003. Once I removed that option I now see over a million lines. THANK YOU!!!!! "Dave Peterson" wrote: This happens when you start a new workbook? If yes, then I bet you have a template file (*.xlt) that was saved as an xl2003 (or below) file. Try deleting (or moving) that book.xlt file (use Windows|Search to find it) TraceyGMEC wrote: Everytime I open Excel 2007 I only see 65,536 rows and before I have everyone on my team upgrade to Excel 2007 I need to make sure that it can go up to 1 million rows. Do I have to install an add-in to get the extra lines? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding more than 65,536 rows in Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 - million rows | Excel Discussion (Misc queries) | |||
how can I shade alternate rows in Excel 2007? | Excel Discussion (Misc queries) | |||
Excel 2007 rows & columns | Excel Discussion (Misc queries) | |||
How do I view the maximum rows in Excel 2007 (Million Rows)? | Excel Discussion (Misc queries) |