Spreadsheet not allowing to inserts a column
Spreadsheet not allowing to inserts a column
(OP)
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/getfile.aspx?folder=1...
something simple i am sure
thanks in advance for your help
regards ... gary
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/getfile.aspx?folder=1...
something simple i am sure
thanks in advance for your help
regards ... gary





RE: Spreadsheet not allowing to inserts a column
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Spreadsheet not allowing to inserts a column
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
RE: Spreadsheet not allowing to inserts a column
Best to you,
Goober Dave
Haven't see the forum policies? Do so now: Forum Policies
RE: Spreadsheet not allowing to inserts a column
RE: Spreadsheet not allowing to inserts a column
Glad you got it fixed!
Best to you,
Goober Dave
Haven't see the forum policies? Do so now: Forum Policies