I have an Excel workbook with approx 20 worksheets that is approx 14 Meg in size. Each of these worksheets has approx 250 rows and 90 columns. This is a consolidation worksheet and, as such, consolidates data from multiple workbooks/worksheets in each of these tabs. This is done through embedded links in many of the cells of each of the worksheets. These links are updated as needed when there have been changes in any of the underlying linked workbooks. This is done through macros. As a result, data is stored in this workbook when the links have been first updated.
I have two questions related to this workbook:
1. The size of this workbook seems very large considering the size of each related worksheet. Is this due to the embedded links? Is there any way to compress this workbook and reduce any artificial size?
2. Is there a way to "zero out" the data in the workbook so that only a template with all the defined links is left (i.e., no updated links to bring in any data)?