| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How may I add more than 256 columns to an Excel spreadsheet?
I am trying to create a horizontal 12 month calendar in an Excel spreadsheet.
I need 370 columns. Is there anyway to accomplish this within Excel? |
|
#2
|
|||
|
|||
|
SPO, excel only has 256 columns
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "SPO" wrote in message ... I am trying to create a horizontal 12 month calendar in an Excel spreadsheet. I need 370 columns. Is there anyway to accomplish this within Excel? |
|
#3
|
|||
|
|||
|
You'll have to put the continuation on a second sheet.
- D Hilberg |
|
#4
|
|||
|
|||
|
No, sorry. 256 is an absolute limit.
HTH. Best wishes Harald "SPO" skrev i melding ... I am trying to create a horizontal 12 month calendar in an Excel spreadsheet. I need 370 columns. Is there anyway to accomplish this within Excel? |
|
#5
|
|||
|
|||
|
Do you know of any other program, beside Microsoft Project that might work?
Thank you! "Harald Staff" wrote: No, sorry. 256 is an absolute limit. HTH. Best wishes Harald "SPO" skrev i melding ... I am trying to create a horizontal 12 month calendar in an Excel spreadsheet. I need 370 columns. Is there anyway to accomplish this within Excel? |
|
#6
|
|||
|
|||
|
SPO wrote:
Do you know of any other program, beside Microsoft Project that might work? Thank you! "Harald Staff" wrote: No, sorry. 256 is an absolute limit. HTH. Best wishes Harald "SPO" skrev i melding ... I am trying to create a horizontal 12 month calendar in an Excel spreadsheet. I need 370 columns. Is there anyway to accomplish this within Excel? Nearly any other database program. I use PostgreSQL, MySQL, and FileMaker in this respect. Access can do the job, but I wouldn't purchase it over FileMaker. |
|
#7
|
|||
|
|||
|
Access has a limitation of 255 fields in a table.
(Not saying that a field for each day is reasonable database design -it would be awful) HTH. best wishes Harald "KJ" skrev i melding ... I need 370 columns. Is there anyway to accomplish this within Excel? Nearly any other database program. I use PostgreSQL, MySQL, and FileMaker in this respect. Access can do the job, but I wouldn't purchase it over FileMaker. |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How may I add more than 256 columns to an Excel spreadsheet?
There is no way Access can accept more than Excel.
Access has the same limitation that Excel has "KJ" wrote: SPO wrote: Do you know of any other program, beside Microsoft Project that might work? Thank you! "Harald Staff" wrote: No, sorry. 256 is an absolute limit. HTH. Best wishes Harald "SPO" skrev i melding ... I am trying to create a horizontal 12 month calendar in an Excel spreadsheet. I need 370 columns. Is there anyway to accomplish this within Excel? Nearly any other database program. I use PostgreSQL, MySQL, and FileMaker in this respect. Access can do the job, but I wouldn't purchase it over FileMaker. |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How may I add more than 256 columns to an Excel spreadsheet?
If it was in access you would probably be switching the order of things
so that the excell rows would become the columns and the excell columns would become the rows. In that case, in a sense the sky is the limit.) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
| How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
| How do i copy columns of data in notepad into excel? | Excel Discussion (Misc queries) | |||
| Why does my excel have numbered columns and rows | Excel Discussion (Misc queries) | |||
| Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
Hybrid Mode
