QAm2sLu4/0.jpg' alt='Get File Owner Using Vba' title='Get File Owner Using Vba' />How to reduce a huge excel file. I have worked extensively in Excel and have found the following 3 points very useful. Find if there are cells which apparently do not hold any data but Excel considers them to have data. You can find this by using the following property on a sheet. Active. Sheet. Used. Range. Rows. Count. Active. Sheet. Used. Range. Columns. Count. If this range is more than the cells on which you have data, delete the rest of the rowscolumns. You will be surprised to see the amount of space it can free. Convert files to. XLSM format is to make Excel compliant with Open XML, but there are very few instances when we actually use the XML format of Excel. This reduces size by almost 5. Optimum way of storing information. For example if you have to save the stock price for around 1. Open, High, Low, Close for a stock, this would result in. Instead, of using separate columns for Open,High,Low,Close save them in a single column with a field separator. Open High Low Close. You can easily write a function to extract info from the single column whenever you want to, but it will free up almost 23rd space that you are currently taking up. I have a small and simple file in. XLS with only one sheet, on this sheet just many cells with small text on number. Kb But I made a lot of changes. I am using this class successfully to generate PDFs. You Have The Right To Remain Silent. I have a problem. I am pulling data from a database adding customer information and parts information together. This site uses cookies for analytics, personalized content and ads. By continuing to browse this site, you agree to this use. Learn more. For all general questions relating to Excel but not including VBA or formulas. Home Getting Started. VBA Programming Variables. Part Section Conditional Logic. Strings and String Functions. Part Section. This Tutorial Covers. Using FILES Function to Get a List of File Names from a Folder Using VBA Get a List of All the File Names from a Folder Using VBA Get a List. InformationWeek. com News, analysis and research for business technology professionals, plus peertopeer knowledge sharing. Engage with our community.