 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / December 2006I Need More Than 256 columns
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 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 > 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 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 >Hi Yosi_lb > [quoted text clipped - 13 lines] >> >> thanks 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 On 23 Dec 2006 01:05:41 -0800, "RichardSchollar" <richardschollar@hotmail.com> wrote: >Hi Yosi_lb> >Only with Excel2007 (it has lots of columns). Your other option from [quoted text clipped - 10 lines] >> >> thanks Thanks for the reminder Jim <shudder> Gord >Gord, >Please don't ask questions like that. Aaron is still out there. <g> [quoted text clipped - 27 lines] >>> >>> thanks Gord Dibben MS Excel MVP 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 > Just curious.......why would Access be better? > [quoted text clipped - 21 lines] > >> > >> thanks > Hi Yosi_lb > [quoted text clipped - 13 lines] >> >>thanks 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 >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.  SignatureMichael Bednarek http://mbednarek.com/ "POST NO BILLS" >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. Here's the URL for downloading SQL Server 2005 Express: http://msdn.microsoft.com/vstudio/express/sql/register/default.aspx And if you download and install SQL Server 2005 Express, you should also download and install Books Online (BOL): http://www.microsoft.com/downloads/details.aspx?FamilyId=BE6A2C5D-00DF-4220-B133 -29C1E0B6585F&displaylang=en 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. > 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 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.