Forum Discussion
Can no longer insert rows on a worksheet
I'm working in a large spreadsheet and have been successfully inserting rows all day long. Now all of sudden I can no longer insert. I've tried everything I can think of. I've attached a copy.
I have no reason to disbelieve you, but I can insert rows in your workbook without problem.
Does the problem persist after quitting Excel, then opening the workbook again?
If yes: does it persist after restarting your computer?
3 Replies
I have no reason to disbelieve you, but I can insert rows in your workbook without problem.
Does the problem persist after quitting Excel, then opening the workbook again?
If yes: does it persist after restarting your computer?
HansVogelaar Yesterday after encountering the problem, I did close the file and re-open. But I did not close Excel entirely. You are absolutely correct that today my problem is solved. Thank you Hans.
Older versions of Excel work fine, this just started for me a couple of weeks ago and is a royal pain to the point that Excel is USELESS to me right now! I used to be able to highlight, copy a row, and then INSERT the row in a new line. Then I could go in and make an adjustment to a code to cause it to recalculate from an entry in another worksheet. NOW no longer possible.
