Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    Birmingham, West Midlands, United Kingdom
    Posts
    219
    Thanks
    0
    Thanked 0 Times in 0 Posts

    'sticky' file (xl2003sp3)

    The attached file, when unzipped, seems to behave oddly.
    Everything is very slow, whether using the mouse or the keyboard.
    The behaviour is similar on the two machines I've tried.
    The poor performance seems restricted to the sheet called 'application'.
    There is no evidence of hogging resources in Task Manager.
    This behaviour is new.
    Has been well-behaved for several years (and several edits.)
    Comments, please?
    Attached Files Attached Files

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

    Re: 'sticky' file (xl2003sp3)

    I don't notice any slowness in Excel 2002 SP3.

    BTW, I assume that the Loan Application sheet is intended to be protected, so that the user tabs from one unprotected cell to another.
    However, the Name and Date of Birth cells are locked, so that they cannot be filled in if the sheet is protected.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    Birmingham, West Midlands, United Kingdom
    Posts
    219
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'sticky' file (xl2003sp3)

    I'll watch this. May be a non-Excel challenge.
    The protection was (largely) removed to aid my editing what other users normally can't.
    It's designed to be partly populated by stuff from elsewhere, which you, Hans, gave me a better way to do than recording a load of copy + paste operations.

  4. #4
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    Birmingham, West Midlands, United Kingdom
    Posts
    219
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'sticky' file (xl2003sp3)

    Happy Outcome: although there was no problem, it seems, in the Netherlands, there was here.
    Solution was to open the file in Open Office, do nothing, save as .xls in Open Office and open in Excel.
    Problem gone, at least for the present.
    As one who's more interested in Outcomes than Processes (whilst having some curious regard for the latter), this is fine.
    Which is not to understate my gratitude to those here and elsewhere who make up for the shortcomings both of we lowly Users and of the paid functionaries in Redmond who sometimes don't get it right first time.
    As I don't, either.

Posting Permissions

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