Thanks Thanks:  0
Likes Likes:  0
Needs Pictures Needs Pictures:  0
Picture(s) thanks Picture(s) thanks:  0
Results 1 to 6 of 6
  1. #1
    FenceFurniture's Avatar
    FenceFurniture is offline The prize lies beneath - hidden in full view
    Join Date
    Oct 2010
    Location
    1017m up in Katoomba, NSW
    Posts
    10,649

    Default Completely bizarre behaviour in Excel

    A few weeks or so ago I started getting the most odd behaviour in Excel - I don't think this was anything to do with an update, but I can't be sure.

    Win 10, Office 2016.

    I have a spreadsheet that has the top row and columns A-E frozen (so I click in F2 and freeze the panes). Here it is:

    Capture.jpg

    It normally behaves as you would expect it to. In the top line I have a whole bunch of shapes that have macros linked to them. They are mostly "jump to" but one is for sorting and another is for a major review of fonts etc (it's a very large sheet with about 2500 highly formatted lines).I'll come back to this macro later....

    It still scrolls as it should....until I paste a cell - any cell. What happens then is that as I scroll down, once I get to that cell then everything ABOVE the frozen line jumps around like crazy and everything BELOW it stays still until I stop scrolling. At that point the lines underneath catch up, but the top line is rolled halfway up so that I can usually not see the shapes that have the macros linked to them. If I scroll to the right then the first 5 columns get the jitters too.

    Here it is caught mid-jitter (even line 2 "AUSTRALIAN" has jumped above the freeze line):

    Capture2.jpg

    If I scroll up to the top, there will be TWO occurrences line 2! One above the freeze line and one below it.
    If I then unfreeze the panes, refreeze them, all is good again until I do another paste (other things probably affect it too, but unknown).


    Referring back to that macro the checks and formats all the fonts: it used to take about 10-15 seconds to run, but now it takes 150 seconds, and I haven't increased the code and nor have I added an extraordinary amount of lines to the sheet.


    Back in the day of Office 2003 you were only allowed to have 4000 formatted cells in a workbook. I don't know if there is a limit on that now but if there is it is certainly increased way above that. This is an extensive workbook, and this sheet alone would have in excess of 80,0000 formatted cells (at least 30 columns by 2680 rows). Could this odd behaviour be a result of hitting some limit? Or is it just the usual "FF's weirdo shight that nobody can explain"?

    Maybe it might be suggested that I re-install Excel but that is a nightmare for me - weeks of work. Here is my highly customised Home Ribbon, and I have no idea on how to do this again. It took me a month to get it right when I changed to Office 16 in 2016.

    Capture3.jpg
    Regards, FenceFurniture

    COLT DRILLS GROUP BUY
    Jan-Feb 2019 Click to send me an email

  2. # ADS
    Google Adsense Advertisement
    Join Date
    Always
    Location
    Advertising world
    Posts
    Many





     
  3. #2
    FenceFurniture's Avatar
    FenceFurniture is offline The prize lies beneath - hidden in full view
    Join Date
    Oct 2010
    Location
    1017m up in Katoomba, NSW
    Posts
    10,649

    Default Managed to get a video of this very odd behaviour

    Here is a screenshot video of the supposedly "frozen" top line. Note how the top line jump around but the body of the screen stays completely still ...until I release the scroll bar on the right hand side.

    Attached Files Attached Files
    Regards, FenceFurniture

    COLT DRILLS GROUP BUY
    Jan-Feb 2019 Click to send me an email

  4. #3
    Join Date
    Jun 2005
    Location
    Helensburgh
    Posts
    7,696

    Default

    Brett, as we discussed a while ago, have you tried it on another computer?
    CHRIS

  5. #4
    FenceFurniture's Avatar
    FenceFurniture is offline The prize lies beneath - hidden in full view
    Join Date
    Oct 2010
    Location
    1017m up in Katoomba, NSW
    Posts
    10,649

    Default

    I may have forgotten about that..... but I don't have another computer. Thing is, it's not just that spreadsheet so whatever it is, it's something to do with Excel itself. I'm thinking that somehow or other, my Excel has some small corruption in it, so another computer isn't going to tell me anything (i.e. I would expect it to work properly).
    Regards, FenceFurniture

    COLT DRILLS GROUP BUY
    Jan-Feb 2019 Click to send me an email

  6. #5
    Join Date
    Jun 2005
    Location
    Helensburgh
    Posts
    7,696

    Default

    I agree but nothing tried nothing gained.
    CHRIS

  7. #6
    FenceFurniture's Avatar
    FenceFurniture is offline The prize lies beneath - hidden in full view
    Join Date
    Oct 2010
    Location
    1017m up in Katoomba, NSW
    Posts
    10,649

    Default

    Djawannabe the guinea pig?
    Regards, FenceFurniture

    COLT DRILLS GROUP BUY
    Jan-Feb 2019 Click to send me an email

Similar Threads

  1. DC motor behaviour
    By Glenn.Visca in forum DUST EXTRACTION
    Replies: 13
    Last Post: 6th August 2015, 11:24 AM
  2. Bizarre Timbers!
    By Willy Nelson in forum WOODTURNING - PEN TURNING
    Replies: 8
    Last Post: 29th March 2010, 09:07 AM
  3. Another bizarre eBay offering
    By Mirboo in forum HAND TOOLS - UNPOWERED
    Replies: 15
    Last Post: 8th October 2006, 10:03 PM
  4. Sum sing bizarre.
    By Wongo in forum NOTHING AT ALL TO DO WITH WOODWORK
    Replies: 29
    Last Post: 3rd February 2006, 05:12 PM
  5. Bizarre Holidays - April
    By oges in forum WOODIES JOKES
    Replies: 1
    Last Post: 2nd April 2001, 09:03 PM

Posting Permissions

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