Excel taking long time to save!

Problem

Excel taking long time to save!

When trying to save a file in Microsoft Word or Excel, it’s taking too much time to save the file.

Symptoms

Word and Excel seem to take an excessive amount of time to save a file.

Possible Reasons & Resolutions

1. It may have many temporary *.emf files on the computer created by Excel. 

Cleaning or deleting them may be positive. 

These are temporary files created by excel each time you open, add, change, etc... an Excel file. 

Over time, not only does your pc accumulate a lot of these files, but they can also become corrupt. To use Excel often, you would require to check for and delete these *.emf files.

Navigation In Windows XP

Start-->Search-->files & folders-->Local Disk



Enter *.emf in the file name in box and then press FIND/SEARCH.

 Navigation In Windows 7

            Start-->Run

Enter *.emf in the file name in box and then press ENTER.


 

2. It could also be corrupted the Excel in some manner. If this occurs only with this one file, make a copy of the file to a removable device and then remove all traces of the file from your computer. Copy the file back to your computer and see if there is a difference.

3. We can also exclude any recent update(s) of various driver(s) like printer.

4. Does the workbook contain any ActiveX controls? If so then you may consider replacing them with the Form's controls.

5. Is this a file that has been around for a while, adding data, removing data? The truth is that Excel file can get corrupted in one or another way. A slow open/saving can indicate an issue with the file, especially now that external aspects have been investigated. Creating a new workbook file & move the sheets to the new file.  

Helpful Reference regarding this post: 1. www.symantec.com 2. http://social.technet.microsoft.com 3. http://p2p.wrox.com 4. http://answers.microsoft.com 5. http://www.excelforum.com