VBA to save entire workbook with less time

Shruder,
Depending on the workbook function and layout ...You could export the data sections to a txt file and import the txt file after opening the workbook. Other wise use as many worksheet functions as possible as the vba syntax will increase the file size and slow the calx's down.
Hope that helps

I think it is not the way how you save it.
Its is all the calculation that must be done.
Take a look at that for quicker savetime

It looks like your screenshot is showing us a .xlsb file that is 2.75MB. That should not take over 10 minutes to save. It's not that big. If you would like us to experiment with it, we accept .xlsb or .zip attachments up to 9.77MB.

Originally Posted by Shruder

I need the calculations to be turned on before the save so they can work.

I'm not clear on your expectation here. The calculation setting is for the Excel app, not for the file. In manual mode, it will recalculate before a save anyway. Turning on auto, saving, then going back to manual does not have any effect compared to leaving in manual.

Originally Posted by Shruder

I moved to local drive from sharepoint and it took 5 mins longer to save.

That is mostly likely because of network overhead rather than SharePoint itself. Fifty percent longer than a local save doesn't surprise me.