| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| keeping a toolbar attached to a workbook | Excel Discussion (Misc queries) | |||
| Linking a cell to another workbook cell based on a variable name | Excel Discussion (Misc queries) | |||
| queries (sql) in ACCESS help | Excel Discussion (Misc queries) | |||
| Shared Workbook - Defining Access Rights | Excel Worksheet Functions | |||
Threaded Mode
