How may I add more than 256 columns to an Excel spreadsheet?

S

SPO

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?
 
P

Paul B

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
 
K

KJ

SPO said:
Do you know of any other program, beside Microsoft Project that might work?

Thank you!

:
Click to expand...
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.
 
H

Harald Staff

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
 
B

BigD

There is no way Access can accept more than Excel.
Access has the same limitation that Excel has
 
R

Ron2006

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.)
 
Top