Vlookup and file size

A

Alex532

I have created a macro that performs a bunch of vlookups on another
sheet in my workbook. I then have the macro copy and paste special the
values from the formulas to eliminate all of the vlookups. I did this
thinking that the file size would return to normal, however I still
have a 4.3mb file. how can I get the file size back down? Is the data
being stored somewhere else within my file?

Thanks,
Alex
 
A

Alex532

I did try to remove unused cells, but it doesn't seem to change the file
size. The size of the file does not change until I use the vlookups, so
I think it must have something to do with the data that I copied and
pasted special back over the vlookups.
 
A

Alex532

That is a good question. I went back and did it again and made sure
saved it, but it is still the same size. That does not surprise m
though, since the unused space it is deleting never had any data in i
to begin with
 
G

Gord Dibben

I'm out of suggestions except for you checking the macro code to see what gets
swapped around when you do the paste special values.

One more thing.

Where does CTRL + End take you on your worksheet?

End of data or somewhere else?

Any objects embedded in the workbook on any sheet(s)?


Gord
 
A

Alex532

I tried deleting sets of data one by one and determined that the large
file was just due to the extremely large amount of data I had in my raw
data tab. I thought it was from the vlookups leaving someting behind,
but it wasn't.

Thanks for your help.
 
Top