![]() |
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