Closed Thread
Results 1 to 3 of 3
  1. #1
    Registered User
    Join Date
    12-29-2009
    Location
    Washington State, USA
    MS-Off Ver
    Excel 2008 - Mac
    Posts
    15

    Workbook saves and opens really slooooooow

    I started creating a workbook in 2004 but had to change to 2008. As I continued working in 2008, (It IS backward compatible isn't it?), I started getting a *LOT* of XL crashes and hangs.

    Thanks to several people on this forum, I realized that I had a corrupted workbook.

    So, I copied and pasted the 08 sheets into a NEW 08 workbook. After recreating my NAMES, everything seemed to work well.

    But, I now notice that everything is incredibly S L O W W W W W W W W and the 08 WB is now grown from 350k to 16 mb!

    My app is pretty simple. I have about 20 rows of data by 20 columns. This raw data is summarized in 3 pivot tables. PT1 is the original and the others (PT2 and PT3) are based on PT1. I have destroyed and recreated the PivotTables. No help.

    I also have a graph that is based on PT2. It works.

    One weird thing is that when I started the 08 app, I was asked about LINKS to the old WB. Since this is a stand alone app, I selected "UNLINK".
    Could this have something to do with the size?

    How do I get my app back to it's previous smaller size?

    Thanks for thinking about this....

  2. #2
    Forum Moderator teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    2003 & 2010
    Posts
    10,033

    Re: Workbook saves and opens really slooooooow

    synergy46,

    the Tips & Tutorials is not for posting questions. Please have a look at the forum rules before your next post.

    Moved to http://www.excelforum.com/excel-2008-help/
    teylyn
    Microsoft MVP - Excel
    At Excelforum, you can say "Thank you!" by clicking the icon below the post.

    Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.

  3. #3
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    10,477

    Re: Workbook saves and opens really slooooooow

    Mojito connoisseur and a dabbler in Cisco
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

Thread Information

Users Browsing this Thread

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

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.2.0