Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jul 2004
    Location
    Marietta, Georgia, USA
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Slow Moving Spreadsheet (Excel 2003)

    <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35> I have a relatively small spreadsheet that contains no formulas. It is so slow it is excrutiating. Not only inserting/deleting columns and rows, but just generally entering data in a cell.
    Any ideas on what is wrong and what I can do?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Slow Moving Spreadsheet (Excel 2003)

    Does it help if you
    - Create a new workbook.
    - Open the 'slow' workbook.
    - Select the used range of the first worksheet.
    - Copy it to the clipboard, then paste it into the first worksheet of the new workbook.
    - Repeat for the other worksheets (if any).
    - Use the new workbook instead of the old one.

  3. #3
    3 Star Lounger
    Join Date
    Mar 2003
    Location
    Beddau, Mid Glamorgan, Wales
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Slow Moving Spreadsheet (Excel 2003)

    Hi Diane:

    If I have a workbook behaving in the way you describe - for no apparent reason! - I first save it as a web page and close the file, then open the .htm file (in Excel) and resave it as an Excel file.

    More often than not this resolves the problem.
    Regards,

    Tony
    [s] [/s]
    www.SylviArtist.com

  4. #4
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    163
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Slow Moving Spreadsheet (Excel 2003)

    I agree with Tony, you might want to resave your file and check what format it is in.

    I've had similar problems when a spreadsheet is in web page format. There is one dataset I need to download from the net and even though I save is as Excel and it has the .xls extension the file is in web page format. I need to re-save as excel format. If you do pivot tables on a spreadsheet in web page format, it creates all kinds of sub folders in your directory and it is very difficult to go back in several days and alter the pivot tables. The entire thing is very slow.

Posting Permissions

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