It's really hard to give generic advice - much better to see the specific file, to identify how it may be improved / optimized.

A couple of observations, though:
- Try using Index / Match instead of Vlookup. It nearly always reduces memory used.
- Try to make sure you separate your data / business logic / visualisations.
- Normalise data wherever possible. Create normalised lookup tables.