Expanding workbook columns?

[Pezgordo]

I have a workbook that I am using that ends at column IV. I tried to add a few new columns so I could insert some additional information and I received a message saying that "Excel cannot shift nonblank cells off of the worksheet."

Is there anyway for me to add additional columns to a workbook? I have other workbooks that I am using that go far beyond column IV, so I do not know why this particular one ends at column IV.

Thank you,

Tim

 

[VoG]

IV was the last column in Excel 2003 and earlier. If you are using a later version make sure that it is saved in xlsx or xlsm format.

Also see http://www.mrexcel.com/forum/showthread.php?t=74218

 

[jim may]

Is there anyway for me to add additional columns to a workbook?

Yes, upgrade to Excel 2007 or 2010 - They have 16384 Columns available.

 

[Pezgordo]

I do have Excel 2007, however I believe this worksheet was originally created in an earlier version (2003?). How can I save this worksheet into the 2007 version?

 

[VoG]

Use Save As and specify either .xlsx or .xlsm

 

[Pezgordo]

Use Save As and specify either .xlsx or .xlsm

Not to sound too stupid, but when I hit Save As and I click on the Save as type drop down menu, I do not have .xlsx or .xlsm available.

 

[VoG]

The Save As Type dropdown should include

Excel Workbook (*.xlsx) and

Excel Macro-enabled Workbook (*.xlsm)

 

[Pezgordo]

Yes you are correct, when I tried saving it in Excel Macro-enabled Workbook (*.xlsm) I received a message saying that Excel Macro-enabled Workbook (*.xlsm)already exists. I saved it again, however the last column is still IV.

 

[VoG]

Try this: click the Office button (top left), click Excel Options, click Save, in Save files in this Format select Excel Macro-enabled Workbook (*.xlsm) then click OK. Then save, close and re-open the workbook.

 

[Pezgordo]

I am such a bonehead. It was saved to the desktop but I kept clicking on the old icon.Thanks Peter.