Spreadsheet not allowing to inserts a column

[GPowers2]

people,

I have a spreadsheet that was created in Excel 2003 and am now using Excel 2010
the spreadsheet refuses to allow me to add a new column and stops at IV with no columns
appearing after that .... that column IV also has a drop shadow which indicates to me that it
has some characteristic added that prevents activity beyond this column,
I do get dialogue which i have tried to make sense off but still struggling

http://files.engineering.com/getfil...0a7-b183-5548ad7c1f41&file=EXCEL_dialogue.png

something simple i am sure

thanks in advance for your help

regards ... gary

 

[IRstuff]

A live worksheet would be more useful. The max is XFD in my version

TTFN
faq731-376

 

[GPowers2]

Hello IRstuff

content of spreadsheet maybe a bit sensitive, costs etc. having said that I could,
and would have stripped out this info if not for the fact that i have managed to fix it
story goes that EXCEL 2003 culd only manage 256 columns ( a limit i had reached )
Although I am using EXCEL 2010 with many more columns available i simple had not
done a SAVE AS to the new rev ( .xlsx) I had continuly been saving to original format 2003
and so up against the 256 limit.
I saved to .XLSX and all is good ..

regards .. gary

 

[DRWeig]

When you open an old-format Excel file (.xls), Excel keeps it in compatibility mode to mimic the 2003 version. This might work: Do a save-as, and choose the new format (Excel 2010 spreadsheet, or .xlsx). Re-open the new file, and you should have the ability to insert columns and go waaaaayyyy past column IV. Might not work, but it's worth a quick try.

Best to you,

Goober Dave

Haven't see the forum policies? Do so now: Forum Policies

 

[zelgar]

Also, you can always try a simple copy & past of the old spreadsheet into a new one. Simply right click the space above Row 1 and to the left of column A and copy the sheet & paste it in a new spreadsheet. Save in 2010 format and see if that works.

 

[DRWeig]

GPowers2, It looks like you beat me by seconds in posting.

Glad you got it fixed!

Best to you,

Goober Dave

Haven't see the forum policies? Do so now: Forum Policies