I have a workbook with 24 worksheets. 22 of the worksheets use an Excel
query to pull data from Access tables and queries. The data is pulled "as
is" there are no groupings or fomulas of any sort. After all the queries
update on open the size of the workbook has been as large as 233mb. When the
queries update and the data is all null the workbook is still 21mb without
any data. Is there any was to compact in Excel like you can in Access? I
know there is code behind the queries but I am not a coder can you compact
the code? Any help would be great!