Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2399029%22%20slang%3D%22en-US%22%3EExcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2399029%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20one%20of%20my%20excel%20files%20the%20function%20%22add%20a%20row%22%20is%20suddenly%20disabled%20-%20in%20the%20function%20table%20at%20the%20top%20of%20the%20file%20as%20well%20when%20I%20highlight%20a%20row%20and%20try%20to%20click%20on%20%22add%20row%22.%20What's%20wrong%20with%20this%20file%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2399029%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2399082%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2399082%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1066928%22%20target%3D%22_blank%22%3E%40Hans_Hasler%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMake%20sure%20that%20the%20worksheet%20has%20not%20been%20protected.%20Activate%20the%20Review%20tab%20of%20the%20ribbon.%20If%20the%20'Protect%20Sheet'%20button%20is%20highlighted%2C%20click%20it%20to%20turn%20the%20protection%20off.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAlso%2C%20make%20sure%20that%20the%20sheet%20does%20not%20contain%20a%20table%20that%20stretches%20to%20the%20very%20bottom%20of%20the%20worksheet%20(row%201048576).%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

In one of my excel files the function "add a row" is suddenly disabled - in the function table at the top of the file as well when I highlight a row and try to click on "add row". What's wrong with this file?

2 Replies

@Hans_Hasler 

Make sure that the worksheet has not been protected. Activate the Review tab of the ribbon. If the 'Protect Sheet' button is highlighted, click it to turn the protection off.

 

Also, make sure that the sheet does not contain a table that stretches to the very bottom of the worksheet (row 1048576).

@Hans Vogelaar 

thanks so much, it helped