If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Where are the extra columns and rows?
Hi-
In 2007, there are supposedly available over a million rows and over 16000 columns, but all I've been able to get are the 256 by 65536 in all the other excel versions. So......what are I doing wrong? Thanks for your help! |
#2
|
|||
|
|||
Where are the extra columns and rows?
You need to save your file as an .xlsmclose itopen it
-- Don Guillett Microsoft MVP Excel SalesAid Software "frankoamerican" wrote in message ... Hi- In 2007, there are supposedly available over a million rows and over 16000 columns, but all I've been able to get are the 256 by 65536 in all the other excel versions. So......what are I doing wrong? Thanks for your help! |
#3
|
|||
|
|||
Where are the extra columns and rows?
Most likely you are still using an old file (XLS) format.
Use SAVE AS to save it into Excel 2007 format (XSLX) extension and you will get the extra rows and columns. You can also see the extra rows/columns if you open a new workbook. "frankoamerican" wrote: Hi- In 2007, there are supposedly available over a million rows and over 16000 columns, but all I've been able to get are the 256 by 65536 in all the other excel versions. So......what are I doing wrong? Thanks for your help! |
#4
|
|||
|
|||
Where are the extra columns and rows?
FYI - in Excel 2007 (I am sure you know this... this if for the benefit of
other users) XLSM is for workbooks with macros... XLSX is used for workbooks without macros. "Don Guillett" wrote: You need to save your file as an .xlsmclose itopen it -- Don Guillett Microsoft MVP Excel SalesAid Software "frankoamerican" wrote in message ... Hi- In 2007, there are supposedly available over a million rows and over 16000 columns, but all I've been able to get are the 256 by 65536 in all the other excel versions. So......what are I doing wrong? Thanks for your help! |
#5
|
|||
|
|||
Where are the extra columns and rows?
Thank you!
"Sheeloo" wrote: FYI - in Excel 2007 (I am sure you know this... this if for the benefit of other users) XLSM is for workbooks with macros... XLSX is used for workbooks without macros. "Don Guillett" wrote: You need to save your file as an .xlsmclose itopen it -- Don Guillett Microsoft MVP Excel SalesAid Software "frankoamerican" wrote in message ... Hi- In 2007, there are supposedly available over a million rows and over 16000 columns, but all I've been able to get are the 256 by 65536 in all the other excel versions. So......what are I doing wrong? Thanks for your help! |
#6
|
|||
|
|||
Where are the extra columns and rows?
Thank you, Don!
"Don Guillett" wrote: You need to save your file as an .xlsmclose itopen it -- Don Guillett Microsoft MVP Excel SalesAid Software "frankoamerican" wrote in message ... Hi- In 2007, there are supposedly available over a million rows and over 16000 columns, but all I've been able to get are the 256 by 65536 in all the other excel versions. So......what are I doing wrong? Thanks for your help! |
Thread Tools | |
Display Modes | |
|
|