Help saving large multiple worksheet Excel 2013 file

[Benji Jeff]

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

[Paul Cherian]

Hi Benji,

Could you please send me the file in .xlsx format. Let me have a look on this and let you know the solution.

Regards,

Paul Cherian