 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / September 2007Excel 2007 column limit
I have both excel 2003 and excel 2007 which is part of MS office enterprise 2007 installed on my computer. I was told that the new excel 2007 can support column limit 16,384. but I found it still has only 256 column, does someone knows why? Thanks! Lan You are in 2003 mode. > I have both excel 2003 and excel 2007 which is part of MS office enterprise > 2007 installed on my computer. I was told that the new excel 2007 can support [quoted text clipped - 3 lines] > Thanks! > Lan Are you looking at an Excel 2003 workbook in Excel 2007? If you are you'll see compatibility mode after the book name in the title bar and the book name will have an extension of .xls. If you're working with an Excel 2003 workbook in Excel 2007, you'll have 256 columns and 16,384 rows. If you want to convert your Excel 2003 workbook to an Excel 2007 workbook which has 16,384 columns and 1,048,576 rows, simply save it as an Excel 2007 workbook (Office button, Save as, Excel workbook). Close the workbook and reopen it. It will now be in Excel 2007 format and the book name in the title bar will have an extension of .xlsx. Excel 2007 allows you to work with both Excel 2007 workbooks and prior release workbooks as well. >I have both excel 2003 and excel 2007 which is part of MS office enterprise > 2007 installed on my computer. I was told that the new excel 2007 can [quoted text clipped - 5 lines] > Thanks! > Lan I should also point out that if you save an Excel 2003 workbook as an Excel 2007 workbook, you will have both workbooks. The Excel 2003 workbook will have an extension of .xls and the Excel 2007 workbook will have an extension of .xlsx. If the book names are the same, just be careful to open the right one. > Are you looking at an Excel 2003 workbook in Excel 2007? If you are you'll > see compatibility mode after the book name in the title bar and the book [quoted text clipped - 6 lines] > title bar will have an extension of .xlsx. Excel 2007 allows you to work > with both Excel 2007 workbooks and prior release workbooks as well.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.