+ Reply to Thread
Results 1 to 2 of 2

Why my workbook takes too much time after pressing Ctrl+S to save

  1. #1
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Why my workbook takes too much time after pressing Ctrl+S to save

    Hello respected gurus and excellers!

    My workbook(that contains 800+ records and a user form for data entry),takes to much time every time when I press Ctrl+S or try to save by Save option.On the status bar of my workbook there appears an increasing strip along with with a message "Saving: Press ESC to cancel.". Is it due to the long code behind my userform or my records are increasing thats why it takes at least ten seconds to complete one save operation?
    or is it some other issue?

    Best Regards
    Imran Bhatti

  2. #2
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: Why my workbook takes too much time after pressing Ctrl+S to save

    Well I found the solution myself.I pressed Ctrl+End which took me to 1048576th row which meant that my work book had to save 1048576 rows whic I used only 800 rows.So I deleted the rows below my last record and resaved. then it took less than a second to complete save operation.
    I hope it will help someone.

    Best Regards
    Imran Bhatti

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel File Takes Long Time to Save
    By mikbsirhc in forum Excel General
    Replies: 6
    Last Post: 10-24-2019, 12:40 AM
  2. Save data from one workbook to another by pressing a command button
    By SpeckM in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-29-2015, 10:22 AM
  3. File Takes Long Time to Save/Not Responding
    By wisedave in forum Excel General
    Replies: 20
    Last Post: 01-17-2015, 05:44 PM
  4. How to Run Macro Directly in Outlook without opening VBE or Pressing Ctrl+F11
    By Novice_To_Excel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-08-2012, 05:38 AM
  5. [SOLVED] Save takes long time
    By Jan in forum Excel General
    Replies: 2
    Last Post: 02-15-2006, 02:10 PM
  6. Excel Bug when Debugging (When pressing CTRL+BREAK): keeps stoping
    By mexage in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-13-2005, 04:06 PM
  7. Excel file takes a long time to save
    By ben@bikecenturies in forum Excel General
    Replies: 1
    Last Post: 02-02-2005, 09:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1