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!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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- trdonja
- Post #13
- Forum: Microsoft: Office
-
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! :)- trdonja
- Post #11
- Forum: Microsoft: Office
-
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...- trdonja
- Post #10
- Forum: Microsoft: Office
-
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...- trdonja
- Post #8
- Forum: Microsoft: Office
-
Max number of columns in Excel 2003
Sorry, correction, it was fneily who posted it first, but you reposted working link.- trdonja
- Post #6
- Forum: Microsoft: Office
-
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.- trdonja
- Post #5
- Forum: Microsoft: Office
-
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...- trdonja
- Post #3
- Forum: Microsoft: Office
-
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...- trdonja
- Thread
- Replies: 12
- Forum: Microsoft: Office
