Remove Table Properties from Workbook

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

Thank you for the reply

There are only three worksheets to this application.

Sheet 1 is 12 columns and 225 rows. The data is a combination of text and numbers (currency format) and no formulas.
Sheet 2 is 16 columns and 35 rows. There is a range of cells 28 x 11 using the formula. . .

Formula:

Please Login or Register  to view this content.

Sheet 3 consists of several named ranges as row source to combo boxes in a user form. There are perhaps 20 total lines of very basic VBA.

The exponential growth of this application reminds me of something that occurred several years in then past when I converted a range to a data table.


Steven

Reviewing "Recent Sources" and "Existing Connections" there is nothing.

When I exported the data from Access it was only one table not the entire DB. However, I will set up a test.

Nope! Only the Access Table.

The features of a table object with this application are unnecessary.

The current range of data is B2:L223. Using Ctrl-End from B2, the cell selected is P1048576

Dropped to 87K.

Thank you

Cheers

Steven