Can I make a worksheet with more than 256 columns?

J

Jim

I need to multiply a large matrix, say 500 by 500, and I'd like to use
the MMULT function.
The kicker is that MMULT seems to be expecting a row of a matrix to
be in a single row of the spreadsheet.
My questions are two;
1) Can I create a worksheet with more than 256 columns?
2) If I'm limited to 256 columns, is there a work around?
I'm not interested in using VBA because I want to apply SOLVER to this
spreadsheet.
Thanks,
Jim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I Need More Than 256 columns 11
Can I have more than 256 columns on my spreadsheet? 4
how can I import a csv file to Excel that has over 256 columns? 2
Test-To-Columns > 256 4
Getting more than 256 columns in Excel 5
How to fake/simulate more than 256 columns 4
Opening a csv with more than 65536 rows 8
how do i get more than 256 columns 2

Top