problems in a workbook add lines

Copper Contributor

I have a large multi tab workbook. Several of the sheets will not let me insert lines. I have done the following to solve it but nothing worked:

 

sheet is no protected

removed add-ins

removed filters

 

and still not working. suggestions?

7 Replies
What happens exactly? Do you get a message from Excel? If so, which message?
Nothing happens, the screen flickers but there is no movement of a cell if I try to insert a cell or if I try a lie nothing happens.
If you start typing on the first empty cell below a table, does the table extend its range?
Where does pressing control+End take you?
I tested this. If I go to sheet in the workbook that will not let me insert lines and control+end it takes me to the last line.
If I type new lines and go to A1 and type again control+end it go to the NEW last line.

If I go to another sheet in the same workbook and do the control+end it takes me past the last line of data. if I type on lines to make the last line past the original last line that the control+end it takes me to correct last line, but if I clear or delete the added lines it them sets the line the new last liine.

Stuart
Hunch: if there are multiple tables on the same sheet, they sometimes get in each others way
Yes but this problem just start and do you have a suggestion on how to fix the issue?

@Sfreides I would really have to see one of the sheets. Can you perhaps copy one sheet for which it doesn't work, remove all data from that table and save that sheet it somewhere so we might download it? (of course after confirming the issue is still there)