Limit number of rows an excel file can have

%3CLINGO-SUB%20id%3D%22lingo-sub-2009433%22%20slang%3D%22en-US%22%3ELimit%20number%20of%20rows%20an%20excel%20file%20can%20have%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2009433%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20macro%20file%20at%20hand.%20I%20save%20it%20as%20workbook%20after%20adding%20values%20and%20upload%20to%20a%20company%20system.%20This%20system%20accepts%20at%20most%2020000%20rows%2C%20also%20I%20need%20at%20most%201000%20rows.%20Right%20now%20I%20can%20see%20around%201million%20rows%20.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20delete%20a%20row%2C%20just%20a%20new%20one%20appears.%20I%20can%20no%20way%20reduce%20number%20of%20rows.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-%20Please%20don't%20offer%20me%20to%20hide%20rows%2C%20since%20hiding%20is%20not%20getting%20rid%20of%20useless%20rows%20they%20are%20still%20there.%3C%2FP%3E%3CP%3E-%20Scroll%20area%20resets%20itself%20everytime.%20It%20is%20useless%20as%20well.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eplz%20let%20me%20now%20if%20there%20is%20a%20macro%20code%20for%20this%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2009433%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2009453%22%20slang%3D%22en-US%22%3ERe%3A%20Limit%20number%20of%20rows%20an%20excel%20file%20can%20have%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2009453%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F909382%22%20target%3D%22_blank%22%3E%40sezinozer%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20not%20sure%20how%20the%20company%20system%20reads%20the%20file%2C%20but%20there%20is%20no%20way%20(I'm%20aware%20of)%20to%20reduce%20the%20number%20of%20rows%20in%20a%20spreadsheet.%20Typically%2C%20a%20system%20can%20read%20where%20the%20data%20exists%20to%20create%20a%20table%20dimension%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have a macro file at hand. I save it as workbook after adding values and upload to a company system. This system accepts at most 20000 rows, also I need at most 1000 rows. Right now I can see around 1million rows . 

 

If I delete a row, just a new one appears. I can no way reduce number of rows.

 

- Please don't offer me to hide rows, since hiding is not getting rid of useless rows they are still there.

- Scroll area resets itself everytime. It is useless as well. 

 

plz let me now if there is a macro code for this

2 Replies

@sezinozer 

I'm not sure how the company system reads the file, but there is no way (I'm aware of) to reduce the number of rows in a spreadsheet. Typically, a system can read where the data exists to create a table dimension

Hi @sezinozer 

 

These rows are not useable unless you write on them.

So, if you want to use certain number of rows and you want to make sure that your colleagues do the same, you can protect the whole rows and just open the ones you want to limit.