hi,
i have very large file(~13000) i did some conditional formats deletion via
macro. i also saved the file via macro.
i noticed that the file size was reduced(~9500). but if i open the reduced
file and close with save it size becomes even smaller (~8000). i believe
there is a way to implement the last reduction via code(and not open&close),
but i do not know how...please advice.
thanks,
--
Miri Tz.

Maybe this will give some insights:

http://www.contextures.com/xlfaqApp.html#Unused

--
Regards,
Tom Ogilvy


"Miri" wrote:

> hi,
> i have very large file(~13000) i did some conditional formats deletion via
> macro. i also saved the file via macro.
> i noticed that the file size was reduced(~9500). but if i open the reduced
> file and close with save it size becomes even smaller (~8000). i believe
> there is a way to implement the last reduction via code(and not open&close),
> but i do not know how...please advice.
> thanks,
> --
> Miri Tz.