Welcome Guest
Log In | Register )
You last visited December 10, 2016, 5:13 pm
All times shown are
Eastern Time (GMT-5:00)

Problem with my excel files

Topic closed. 1 reply. Last post 11 years ago by SirMetro.

Page 1 of 1
lottaloot's avatar - AvatarZ56
United States
Member #3396
January 18, 2004
4867 Posts
Posted: July 17, 2005, 12:44 pm - IP Logged

I notice that now when I hit save in my excel files, that it takes a L-O-N-G time for them to actually save.  I added some things to it but I do not feel that it was that much. 

Does anyone have any ideas why this may occur?  and have any recmmendations for me.

    SirMetro's avatar - center
    East of Atlanta
    United States
    Member #6191
    August 11, 2004
    1389 Posts
    Posted: July 23, 2005, 2:24 pm - IP Logged

    Couple of reasons why Excel can take a long time to save.

    Biggest reason is how many formulas you have in the spreadsheet. One of the most common practice we all have a habit of is to put the formulas in EVERY cell of EVERY Row listed. If you have a few thousand numbers in your sheet, and each row has 3 or more cells with formulas, it can get very tedious for Excel to close out a file. If you noticed in my spreadsheets, the sheets with the lists of numbers ONLY had 1 row with the actuall formulas. The rest of the rows were set to have the data only, making it easier for Excel to shut down. Excel is not having to calculate anything before shutting down.

    Another issue is, you could have external references. Click Edit> and look to see if LINKS is highlighted. If it is, you are referencing a file outside of your spreadsheet, and Excel is trying really hard to update the external file before shutting down. You must kill that link (assuming you do not need it).

    Finally, when is the last time you did basic housekeeping on your hard drive. I always suggest once a week defrag and cleaning of a hard drive to keep optimum performance of the overall system.

    Just a few ideas, hope they help.

    Sir Metro