I developed an Excel application to print inventory labels. Unfortunately, when I imported the data from Access I saved the data as a table. This increased the file size from 60K to 38,000K and slowed processing time to a snail's pace. I converted the table to a range and that slightly increased the processing speed but did nothing for the file size.

Is there a method to remove the table properties and further reduce the process time and file size? I am not fond of the thought of having to copy and paste the VBA, macros and forms to a new workbook.


Thank you.

Steven