Please help on a EXCEL problem *NEW Problem*

[jinglingxl]

Our small office share an big Excel spreadsheet, and everyone enters data on it. So just started today the Excel sheet would not allow us to Insert Rows anymore to the table, and keeps giving the following error message

"To Prevent possible loss of data, Microsoft Excel cannot shift noneblank cells off the worksheet

Try to delete or clear the cells to the right and below your data. Then select cell A1, and save yuor workbook reset the last cell used.

Or, you can move the data to a new location and try again."

I try to do what is descirpted above, no luck. The file can still open and save, but when inserting rows will result the above error everytime.
The file is created with MS Excel 2000, anyone have any clue how I can fix this? Please please help me out.

Thanks.

** Edit, now I've fixed the inserting row problem. But I got a new problem
I am activating the auto filter feature for a file with about 60 tousand
rows. The message "Fixed Objects Will Move" keeps on coming up
everytime a filter is selected. How does one fix this problem?

Now I need help on this problem. :frown:

 

[WW]

do you have a button or picture in your worksheet?

right click on the button,
select "Format Control", select "Properties" and then select "Move and
Size with cells"

 

[OZEE]

Sounds like it's time to move that big spreadsheet into a database. You're approaching the 65536-row limit of an Excel Spreadsheet.

 

[jinglingxl]

Originally posted by: WW
do you have a button or picture in your worksheet?

right click on the button,
select "Format Control", select "Properties" and then select "Move and
Size with cells"

Its a big spreadsheet, we don't usually have button or picture in it. But how can I find it if there is one?

And sorry it's not 60 thousand rows, its 6000 rows.

 

[WW]

Originally posted by: jinglingxl

Originally posted by: WW
do you have a button or picture in your worksheet?

right click on the button,
select "Format Control", select "Properties" and then select "Move and
Size with cells"

Its a big spreadsheet, we don't usually have button or picture in it. But how can I find it if there is one?

And sorry it's not 60 thousand rows, its 6000 rows.

try Edit > go to > special > Objects