close

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 quot;as
isquot; 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!

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()