I Need More Than 256 columns

[yosi_lb]

hi everybody
is it posible to have a spredsheet with more than 256 columns ?
i need to make a spredsheet with 365 columns (1 year)

thanks

 

[RichardSchollar]

Hi Yosi_lb

Only with Excel2007 (it has lots of columns). Your other option from
the MS Office suite would be Access.

If neither of these is a possibility, then you will need to restructure
your data to accommodate it in the existing Excel sheet structure.

Best regards

Richard

 

[Michael Bednarek]

is it posible to have a spredsheet with more than 256 columns ?
i need to make a spredsheet with 365 columns (1 year)

Not in Excel until version 12 (aka 2007). OTOH, Quattro Pro has provided
for 18,276 columns (and the same number of worksheets and 1,000,000
rows) for a long time.

Alternatively, restructure your design or use Access.

 

[Gord Dibben]

Just curious.......why would Access be better?

An Access 2003 table is limited to 255 fields.

Or am I not understanding the rationale behind using Access?


Gord Dibben MS Excel MVP

 

[Jim Cone]

Gord,
Please don't ask questions like that. Aaron is still out there. <g>
Regards,
Jim Cone
San Francisco, USA


"Gord Dibben"
<gorddibbATshawDOTca>
wrote in message
Just curious.......why would Access be better?
An Access 2003 table is limited to 255 fields.
Or am I not understanding the rationale behind using Access?
Gord Dibben MS Excel MVP

 

[RichardSchollar]

Gord

I'd always assumed Access had a higher upper limit on the number of
fields in a table - I see that I was completely and utterly wrong!

That's one less erroneous assumption I'll make in future ;-)

Richard

 

[Gord Dibben]

Thanks for the reminder Jim <shudder>


Gord

Gord,
Please don't ask questions like that. Aaron is still out there. <g>
Regards,
Jim Cone
San Francisco, USA


"Gord Dibben"
<gorddibbATshawDOTca>
wrote in message
Just curious.......why would Access be better?
An Access 2003 table is limited to 255 fields.
Or am I not understanding the rationale behind using Access?
Gord Dibben MS Excel MVP

Gord Dibben MS Excel MVP

 

[Bill Sharpe]

Hi Yosi_lb

Only with Excel2007 (it has lots of columns). Your other option from
the MS Office suite would be Access.

If neither of these is a possibility, then you will need to restructure
your data to accommodate it in the existing Excel sheet structure.

Best regards

Richard

52 sheets with 7 columns each? 12 sheets with 28/30/31 columns? Skip
Saturdays, Sundays, and holidays? 4 quarterly sheets with 90 columns?

There are all sorts of alternatives...

Bill
Bill

 

[Chris O'C via OfficeKB.com]

is it posible to have a spredsheet with more than 256 columns ?
i need to make a spredsheet with 365 columns (1 year)

No. You should restructure your data so that you have one of the columns
indicating the day of year (DOY) to make a tall spreadsheet, not a wide one.
For example:

A B C D
1 DOY Books Paper Pens
2 1 $407 $49 $36
3 2 $398 $52 $51
4 3 $421 $46 $55


Alternatively, you can save the data in SQL Server, which allows up to 1,024
columns per table. Access (even Access 2007) only allows up to 255 columns,
so that wouldn't help. SQL Server 2005 Express is free and available for
download.

 

[Chris O'C via OfficeKB.com]

Here's the URL for downloading SQL Server 2005 Express:

http://msdn.microsoft.com/vstudio/express/sql/register/default.aspx

 

[Chris O'C via OfficeKB.com]

And if you download and install SQL Server 2005 Express, you should also
download and install Books Online (BOL):

http://www.microsoft.com/downloads/...5D-00DF-4220-B133-29C1E0B6585F&displaylang=en

 

[ilia]

Honestly, that sounds like setting yourself up for failure. As it is,
you can only keep a single attribute for each row, on each day - that
doesn't seem very useful. However, that may or may not be the case,
depending on what each row represents for a particular day.