Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
extra columns | Excel Discussion (Misc queries) | |||
Excel 2002: What happen to the extra rows and columns ? | Excel Discussion (Misc queries) | |||
extra rows and columns | New Users to Excel | |||
delete extra columns and rows | Excel Discussion (Misc queries) | |||
how do i delete the extra empty rows and columns that i dont need. | Excel Discussion (Misc queries) |