+ Reply to Thread
Results 1 to 7 of 7

Excel 2007 takes to open, close and save

  1. #1
    Registered User
    Join Date
    05-30-2013
    Location
    Elberta, Al
    MS-Off Ver
    Excel 2007
    Posts
    91

    Excel 2007 takes to open, close and save

    I use excel 2007, I download data daily. 3 of the 13 worksheets in my workbook I use Macros. so my workbook is saved in Excel Macro-Enabled Workbook. I never had a problem before, but lately whenever I try to open the workbook it says not responding... when it does open I have no problem going from worksheet to worksheet or downloading the data or doing the macros in the 3 worksheets... but when I try to save a sheet or save the workbook, all I get is not responding and it takes from 1 to 3 minutes to save or close it.
    I thought at first it was my memorey so I tranfered my workbook to a new laptop and it does the same thing. like I said never had a problem before, but now excell is taking a long time opening, saving and closing. the not responding shows up every time now. anyone know what causes this and how I can prevent this.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,083

    Re: Excel 2007 takes to open, close and save

    How big is the workbook? x Kb? y Mb? z Gb???

    Has it grown recently?

    What is the last row in each worksheet? Is that way beyond your data?

    Do you use a lot of Formatting and/or Conditional Formatting?

    Have you copied a formula to the bottom of one or more columns on one or more sheets?

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    05-30-2013
    Location
    Elberta, Al
    MS-Off Ver
    Excel 2007
    Posts
    91

    Re: Excel 2007 takes to open, close and save

    TMS,

    How big is the workbook? x Kb? y Mb? z Gb??? 5.99 MB (6,287,424 bytes) size on disk 6.00 MB (6,291,456 bytes) is all the Workbook properties has. so over 13 sheets it not that big. that size surprise me.

    Has it grown recently? No

    What is the last row in each worksheet? Is that way beyond your data?
    1 sheet is real long, the download data for it goes from R1 to R1816 Col A to Col AH from Col-A to Col-Z R1 to R85 .
    1 sheet go from R1 to R690 to Col A to Col CA R45
    2 of the sheets go from R1 to R435 from Col A to Col BC. 1 Sheet goes from R1 to
    1 sheet go from R1 to R440 and Col A to Col BO.
    1 sheet go from R1 to R125 Col A to Col I.
    1 sheet goes from R1 to R225 Col A to Col P.
    2 sheet goes fromR1 to R285 Col A to Col EY.
    2 sheets goes from R1 to R135 Col A to Col BM.
    1 sheet goes from R1 to R117 Col A to Col AC
    1 sheet goes from R1 to 120 Col A to Col AH

    Do you use a lot of Formatting and/or Conditional Formatting? yes Formatting 4 sheets. also Conditional Formatting added to 2 of the 4 sheets

    Have you copied a formula to the bottom of one or more columns on one or more sheets? No

    I download same amount of download daily to 6 WS format and con Format 4 sheets copy and paste to 3 WS and get Final
    results on the last worksheet. you guys from the forum help me build this spreadsheet, its works great. but here lately excel
    has come to a crawl. each day after I finish the last sheet I save it to the name and date of the sheet, but that goes to a separate folder and only open again for checking records.

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,083

    Re: Excel 2007 takes to open, close and save

    Can you zip a copy of the file up and unload it? Delete any sensitive data.

    Regards, TMS

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,083

    Re: Excel 2007 takes to open, close and save

    Can you zip a copy of the file up and upload it? Delete any sensitive data.

    Regards, TMS

  6. #6
    Registered User
    Join Date
    05-30-2013
    Location
    Elberta, Al
    MS-Off Ver
    Excel 2007
    Posts
    91

    Re: Excel 2007 takes to open, close and save

    TMS

    sorry I pay for the download info. it cannot be published. I agreed to the rules when I join the club. if I uploaded the info it would be a copy right violation. I do not know another to explain my problem other then what I told you already. guess I will have to find some other way to figure out why my excel has stopped working properly. Thank you for taking time for trying to help with my problem,

  7. #7
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,083

    Re: Excel 2007 takes to open, close and save

    Sorry I can't help then.

    I would be inclined to remove ALL formatting and Conditional Formatting, apart from very basic bold, italic, etc. Try it in a copy of the workbookto see if it makes a difference.

    To be honest, we're not interested in the data, just the structure of the worksheets. If you could replace the sensitive data with dummy values, we might be able to assess the reason(s).


    Regards, TMS

+ 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. How do I open, insert a table, save & close a word file via excel
    By partha.raha in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-15-2015, 12:40 AM
  2. Macro to Open, Save and Close Excel Files
    By az! in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-07-2011, 04:19 AM
  3. Using excel vba to open, save as, and close embedded pdf files
    By mcledavid in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-22-2009, 05:22 PM
  4. File takes forever to open/close
    By Sean Anderson in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-23-2008, 05:32 PM
  5. Open excel file, enter values, save & close
    By JCanyoneer in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-04-2005, 12: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