Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. trdonja

    Max number of columns in Excel 2003

    It is not same as having a real sheet with 18k columns. But so far it seems that the functionalities which come with such implementation will be useful for what I need it. It's just slightly more complicated... Control Toolbox --> More Controls --> Microsoft Office Spreadsheet 10.0 --> Add
  2. trdonja

    Max number of columns in Excel 2003

    Ok, I found out how to get 18000 columns in Excel 2003. A little bit of brainstorming, also from this thread (and links from sites from this thread), pointed me in right direction. Finally! :)
  3. trdonja

    Max number of columns in Excel 2003

    Yeah... I did internet search as well, but I didn't find the referenced article. The original article was posted in August 2005 on this site: http://blogs.msdn.com/b/excel/ The archive goes only to September 2005, so the article is gone. The article that you suggest is not the same article...
  4. trdonja

    Max number of columns in Excel 2003

    Yes, and it is the same team of developers that posted the solution how to circumvent the 256 column limit in Excel 2003. Which is exactly the reason, why I think they were forced to remove the article - in order to start promoting the same "feature" in Excel 2007/2010. As you can see from the...
  5. trdonja

    Max number of columns in Excel 2003

    Sorry, correction, it was fneily who posted it first, but you reposted working link.
  6. trdonja

    Max number of columns in Excel 2003

    Skip, can you tell me please what was on the link that you posted in the referenced thread 2 years ago? The problem is not "storage" sheet, it's the files that I use for collecting/importing data into the file. The structure of such data can be sometimes very hard to control.
  7. trdonja

    Max number of columns in Excel 2003

    By program I mean Excel series, including 2007, 2010 etc. I don't miss anything from new versions, except increased row/column limits. On the other hand I have tested new versions with stopwatch in my hand and the tests I ran were a complete disaster, Excel 2007 was 6-7 times slower at certain...
  8. trdonja

    Max number of columns in Excel 2003

    thread68-1509745 As I see in the thread I've referenced there DOES seem to be a solution, but the article is missing from the site. It seems to me, that article has been removed with an intention for solution to remain unknown. Call me wikileaks paranoid, but the site in qurestion was an Excel...

Part and Inventory Search

Back
Top