ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Workbook with 20+ queries of Access is TOO BIG (https://www.excelbanter.com/excel-discussion-misc-queries/85341-workbook-20-queries-access-too-big.html)

Kevin76

Workbook with 20+ queries of Access is TOO BIG
 
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!


All times are GMT +1. The time now is 12:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com