Thread: Cannot see more than 256 columns in Excel 2007 formats

Wow-- ive been searching all morning-- this is the post for me-- i have the same problem--- i want to go over 256 columns as they are all full but ive opened the file in 2007 version-- then read the older files wont allow over 256 SO i re-saved as suggested as .xlsm DONE but then when editing and going back to my new .xlsm file version in excel 2007 i cant add new columns as the problem before... Any help pleaseeeee im going mad!

I can email over my file

id be so grateful!

thanks
Chris

Reference thread: http://www.excelforum.com/excel-gene...ml#post2139453
Please take a moment to read the forum rules, and in the future do not post in other user's threads, called "hijacking". Post a link to the related thread if necessary.

In Excel 2007,

Make sure your default 'save' format is set to one of the new formats, e.g. "Excel Workbook (*.xlsx)" in Excel Options. (Office button -> Excel Options -> Save).

Once you've made that change, close Excel, then re-open and open your troubled workbook. Re-save as .xlsm and hopefully you should be able to see the expanded columns. If not, please upload it.