Hi, I work with very large excel files and have to send them externally, our
mail limit is 10MB which is often not enough for the file size.
For example, one file has macros, pivots and large amount of raw data across
multiple worksheets. I have read the contextures advice but do not know how
it would work for my file - do you have any ideas of how I can reduce the
size of a complex/dynamic data file as the data ranges are changeable
depending on which macro is used?
Many thanks for your advice. Paula