Giant Excel Workbook!!

[millzy7]

Hi i was working on a workbook that was 1MB when i started, now i've added a module of code, added a reference to Microsoft Access and added one new sheet. Now my workbook is 20MB!!!! Anyone know what could have caused this jump?

Thanks

Frank

 

[ZmrAbdulla]

Try compacting the Access DB
TOOLS > DATABASE UTILITIES > COMPACT & REPAIR.

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.

 

[millzy7]

Would the size of the access db affect the excel sheet?

 

[ZmrAbdulla]

Not sure.. But you said the file size has gone up after setting the reference to the access db

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.

 

[millzy7]

Good point. Is there any "compact Excel" function??

 

[ZmrAbdulla]

I don't think there is one

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.

 

[abaldwin]

I agree that you have a problem with the sheet. I have many VERY large sheets with lots of code in them and they hang around 2 meg not 20.

1. Are you sure you are reading the size right? Sounds dumb but I have done that before.

2. I would copy the sheets to a blank workbook and then export the module to a file and in the new wb import the module. You will probably have to make the references again.

Then see if the new file is also bloated.

Was this file size after you imported some data from access or just sitting there basically blank with a code module in it.

Connecting to and referencing an access db should have no effect on the size of the wb (other than the small amount for the code you added).

Andy Baldwin

"Testing is the most overlooked programming language on the books!

 

[millzy7]

Ok, the reason for the sudden growth in the workbook was this.

I added a new sheet and one of the columns contained a formula in every cell of that column all the way down to the row 65536. It was really only required down to row 200 so i deleted the formula from all the rows below that and like magic my workbook is now only 2MB!

Thanks guys

Frank