Excel File - Saving Takes Long Time

I chose the General Forum to post this question because I can't say with certainty what the cause of my problem is - it may span several separate forums. Help appreciated:

My Excel .xlsm file:
has 6 worksheets
is 1.3mb in size
contains multiple macros
has a pivot table and pivot chart on one worksheet summarising data held in an Excel table in another worksheet.
The file has NO links, queries or connections to other worksheets
Beyond that, it has no particularly unusual components.

When I save the file it takes 90 seconds to save, whatever the modification to the file. During that time excel status changes to "Excel not responding" and CPU usage increases to about 33%

For comparison, a larger file on my PC takes about 2 second to save.

I feel that there may be a corruption in the file but am asking you knowledgeable people whether you have ever experienced similar and could thus point me in a direction to research what is causing my problem.

thanks in advance.

Hi, welcome to the forum.
My guess (reading your short description) is that there are quite some formulas in it or references that are being updated before saving.
For testing you could set calculation to manual before saving and see if that changes the time.
Another possibility is that the drive you're saving it to is a NAS or network drive and my experience with Microsoft is that it scans all the drives and the timeout for each drive is the 'bad guy'
The 'Excel is not responding' is a known 'feature' with the newest Excel versions starting with 2007. You see Excel has the application part and the workbook part. the Application is waiting for the workbook to finish (can be macro loops or more) and therefore displays that message. I fell for it when I was running my pre-2007 versions that worked perfectly and saw this.
I found out that you can just let it run and it completes
Back to your question: try turning off automatic calculation for starters as well as screen updating and events

Okay, let me know, curious to hear what you run into