Columns in version 2007

[London_Calling]

I've just upgraded to 2007 and am finding the number of columns is still limited at 256 (IV) rather than the new 16384 columns - fwiw, it was a clean install rather than an overwrite of a previous version of Excel.

I assume I'm missing the page where I can increase the number . . . am I just having a bad morning?

Any guidance warmly received.

 

[Andrew Poulsom]

That's the case if you open a workbook saved in a previous version in compatibility mode. If you save the workbook as Excel 2007, close and reopen it, you will have more rows and columns.

 

[London_Calling]

You know, I've kind of ignored that compatibility stuff . . . opps!

Saved me a lot of grief. Thang yew.