Tags: Paseti pussytyga dating nicki minajspeed dating madrid baresb and s liquidating corporation2016 new dating site in china to contact membersFree random women video sex chatrandy mcmichael datingOlder adult dating sex sites in jacksonville ncdating znakom ru
Having manually located the cell you know to be your last cell containing legitimate data, highlight the row immediately following it.
Don't forget the private modules of your workbook and worksheets if they house code as well. Then, select File » Import File and import each module and User Form back into your workbook.
Following this process will create a text file of each module and that, in turn, removes all extra baggage that the modules might be holding.
Another mistake is referencing entire columns as the data source for charts and pivot tables rather than just the cells with actual data in them.
To fix these problems, you will need to eliminate all the superfluous formatting and restrict your data source to only the useful range of cells.
If, after performing the previous steps, you still believe your file size is unrealistically large, another possible suspect is referencing unused cells in Pivot Tables and Pivot Charts.
This is true particularly of Pivot Tables, as people frequently reference all 65,536 rows in order to avoid manually updating ranges as new data is added.error in any cells of any formulas that might reference them.Save your workbook and take gleeful note of the change in its file size by selecting File » Properties... If you have macros, now you need to address the modules that the macro code resides in.Now apply the same logic to unwanted formatting lurking in your columns.Locate the cell in the last column containing data and click the column header of the column immediately to the right.Press Ctrl-Shift and the right arrow on your keyboard to highlight all other columns to the right and then select Edit » Clear » All.Don't be tempted to actually delete these rows or columns rather than clearing them, as doing so often causes the dreaded #REF!If this is your modus operandi, use dynamic named ranges for your data sources instead.If you still believe your workbook is too large, it is possible that your workbook or component sheets are corrupt.When you are asked whether you want to export your module before removing it, say Yes, taking note of the path.Do this for each module in turn, as well as for any User Forms you might have.