Hi all,

I have an Excel file that's updated monthly. when it does save its around 16mb and can take up to 12 hours to save, and sometimes just doesn't.
I have tried saving as binary, I have made sure exact size of area to be saved is required, I have tried save with no calculations.
Basically the only reason I need to save it is so that another analysis spreadsheet can pull data from it.
The file is heavily formatted, charts, vlookup tables etc, none of which is needed when analysis spreadsheet links to it.

Can anyone help with this please
Kind regards
Ben