Forum Discussion

Copper Contributor

Dec 22, 2020

Limit number of rows an excel file can have

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 aroun...

excel

Formulas and Functions

Macros and VBA

office 365

adversi

Iron Contributor

Dec 22, 2020

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