- Joined
- Jul 15, 2005
- Messages
- 2,032
- Likes received
- 55
- Thanks received
- 51
- Location
- Lundun
MrsGoof said:I'm using Excel to do some analysis on data. Unfortunately I've run out of columns, they only goes upto 'IV'.
Can I change this anywhere, or will I have to resort to multiple workbooks.
TIA
MG

It's just a simple piece of analysis on some data extracted from a Mainframe DB (NOT SQL based). I cant perform this manipulation using tools available, I could write a program but this would be quite complex, take several days to write and several months to be allowed to run on the production system.TonyEnglish said:What are you doing that means you need more than 256 columns?
Should it be in a database instead?
Lockhouse said:Apparently the next version of Excel (2007) will have 16000 columns and 1 million rows....if you can wait....
Boolean said:You can always use multiple worksheets in the same workbook.
