Vlookup and file size

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

Check out the info here at Debra Dalgleish's site.

http://www.contextures.on.ca/xlfaqApp.html#Unused


Gord Dibben Excel MVP

On Mon, 19 Dec 2005 13:16:12 -0600, Alex532
<Alex532.20axfa_1135020001.1472@excelforum-nospam.com> wrote:

>
>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

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.

You did save the workbook after deleting the unused range?


Gord

On Mon, 19 Dec 2005 14:30:10 -0600, Alex532
<Alex532.20b0wa_1135024500.7027@excelforum-nospam.com> wrote:

>
>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.

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

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


On Mon, 19 Dec 2005 14:49:47 -0600, Alex532
<Alex532.20b1lb_1135025401.455@excelforum-nospam.com> wrote:

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

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.