Unable to add columns in the sheet

[praveen.bitsindri]

Hi,

I am using excel 2003 in my QTP automation framework as an input data sheet.When i tried to add columns in the sheet, i was not able to insert and i was getting a message "To Prevent possible loss of data,Microsoft Office Excel cannot shift nonblank cells off the worksheet.
Try to locate the last nonblank cell by pressing CTRL+END, and delete or clear all in cells between the last cell and the end of your data. Then select cell A1 and save your workbook to reset the last cell used.
Or, you can move the data to a new location and try again". Screenshot of the message is attached.

Please help me in this regard.
My second question, is there any limitation on number of rows and column in a spreadsheet?

Because before inserting columns, i saw there were two empty columns at the end of the sheet column wise, so i was able to add two columns, but after that, i was not able to insert columns.

Note: I am using the sheet, which has been used in my project, I mean this is an old sheet.

 

[wigi]

Excel 2003 has a limit of 256 columns. Excel 2007 increases this limit to 16384.

I see no attached screenshot.

 

[VoG]

This may help http://support.microsoft.com/kb/69491

In Excel 97-2003 the limit is 65,636 rows x 256 columns

In Excel 2007+ it is 1,048,576 rows x 16,384 columns.

 

[praveen.bitsindri]

@ Wigi: i donno how to attach image in this forum

@vog: thnx for the info..

i hav one more doubt..when i made some changes in the existing worksheet, by changes i mean...there were space for two columns only...so i added two columns and some rows...but when i started using the new saved sheet...it was not working properly in my automation framework...i had the backup of the old worksheet..nd when i tried the old one..it was working as expected...


what could be the reason for this wiered behaviour..??

pls help

 

[VoG]

It does sound like strange behaviour. Perhaps rebuild your workbook http://www.mrexcel.com/forum/showthread.php?t=223851