Results 1 to 10 of 10
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Manchester, Gtr Manchester, England
    Posts
    299
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I've been given some filled in spreadsheets which are acting wierd.

    For me even, moving between worksheets is slow. Working in the VBA editor is slow and the code I wrote seems to run in slow motion.

    There appears to be nothing unusual about the spreadsheets.
    Each comprises only a few worksheets, there are <50 rows and about 25 columns max (often <10).
    There were no macros/VBA code until I started writing.
    There are no fancy equations, just a bunch of simply column sums.

    I've simply copied and pasted the data into a new blank workbook to develop the code I needed. Everthing is fine there.

    I'd like to know why they are behaving like this (the owner of the spreadsheets has created a whole bunch of these and they all seem sluggish)

    I have never seen anything like it, very strange. Any ideas?

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Is the filesize unexpectedly large by any chance?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Manchester, Gtr Manchester, England
    Posts
    299
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Doesn't appear so. Biggest is 59kb.

    This file took about 10 seconds to open

  4. #4
    3 Star Lounger
    Join Date
    Feb 2003
    Location
    Runcorn, Cheshire, United Kingdom
    Posts
    372
    Thanks
    0
    Thanked 2 Times in 2 Posts
    Quote Originally Posted by Darsha View Post
    I'd like to know why they are behaving like this (the owner of the spreadsheets has created a whole bunch of these and they all seem sluggish)

    I have never seen anything like it, very strange. Any ideas?
    Might there be hidden links to other spreadsheets that are slowing things down?

    If the owner/creator is creating the separate spreadsheets as extracts from an existing larger one, there may be something relevant in the way he's doing it.

    Just a thought.

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Check Edit, links: are any there?
    Also, are there any querytables in the file which refresh on open?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  6. #6
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Manchester, Gtr Manchester, England
    Posts
    299
    Thanks
    0
    Thanked 0 Times in 0 Posts
    There don't appear to be any Links.

    I haven't got a clue what querytables are (help returned nothing on that phrase) but I suspect there aren't any.

    The user assures me they just typed and formatted each sheet. I'm always a bit mistrustful of spreadsheets though

  7. #7
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Can you attach a copy here? You can replace text with random text if it needs be.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  8. #8
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Manchester, Gtr Manchester, England
    Posts
    299
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Here you go. This is unchanged from what I received.
    Attached Files Attached Files

  9. #9
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    The file opened very quickly for me. Calculations were fast as well.

    One note on the formulas - such as this one =SUM(D10*0.44) in cell D9 on the LE2.1 - MIX1 sheet. There is no need to encase the multiplication within the Sum() function. Nothing is being not added. =D10*0.44 would suffice.

  10. #10
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Manchester, Gtr Manchester, England
    Posts
    299
    Thanks
    0
    Thanked 0 Times in 0 Posts
    No idea what's going on then. Like I said, if I copy/paste this data into a new workbook, the new file opens quickly as expected.

    Just sent it to two colleagues. On one, it opened straight away. On the other, a definite delay, though not as slow as on my pc.

    Thanks for looking.

Posting Permissions

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