| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Maximum Rows and Columns
Just got my new Office 2007 Suite of applications. One reason I wanted the
new Office is that I work with large data files and the capability of 1 million rows and a lot of columns will help me. Unfortunately, I just tried to combine 2 large worksheets that totalled more than 66,000 rows and got the error message that I had exceeded the row maximum. How do I "turn on" the larger row and column capability? Any help would be much appreciated. Thanks. -- PBear |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Maximum Rows and Columns
You probably opened older format Excel files. Office buttonSave as... choose Excel workbook (or macro enables workbook if you
need to), close and re-open. -- Kind regards, Niek Otten Microsoft MVP - Excel "PBear" wrote in message ... | Just got my new Office 2007 Suite of applications. One reason I wanted the | new Office is that I work with large data files and the capability of 1 | million rows and a lot of columns will help me. Unfortunately, I just tried | to combine 2 large worksheets that totalled more than 66,000 rows and got the | error message that I had exceeded the row maximum. How do I "turn on" the | larger row and column capability? Any help would be much appreciated. | Thanks. | -- | PBear |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Maximum Rows and Columns
Niek, you were correct. It should have been intuitive to me, but I didn't
think of it. Thanks for the help. -- PBear "Niek Otten" wrote: You probably opened older format Excel files. Office buttonSave as... choose Excel workbook (or macro enables workbook if you need to), close and re-open. -- Kind regards, Niek Otten Microsoft MVP - Excel "PBear" wrote in message ... | Just got my new Office 2007 Suite of applications. One reason I wanted the | new Office is that I work with large data files and the capability of 1 | million rows and a lot of columns will help me. Unfortunately, I just tried | to combine 2 large worksheets that totalled more than 66,000 rows and got the | error message that I had exceeded the row maximum. How do I "turn on" the | larger row and column capability? Any help would be much appreciated. | Thanks. | -- | PBear |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Maximum Rows and Columns
"PBear" wrote in message
... Just got my new Office 2007 Suite of applications. One reason I wanted the new Office is that I work with large data files and the capability of 1 million rows and a lot of columns will help me. Wouldn't you be better using a proper database application for that sort of quantity? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maximum Columns in Worksheet | Excel Worksheet Functions | |||
| How do I view the maximum rows in Excel 2007 (Million Rows)? | Excel Discussion (Misc queries) | |||
| Extending the Maximum no. of Columns | Setting up and Configuration of Excel | |||
| How can I extend the maximum # of columns to 500 | Setting up and Configuration of Excel | |||
| How can I extend the maximum # of columns to 500 | Setting up and Configuration of Excel | |||
Hybrid Mode
