Thanks: 0
Likes: 0
Needs Pictures: 0
Picture(s) thanks: 0
Results 1 to 6 of 6
-
17th August 2020, 11:47 AM #1
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
-
17th August 2020 11:47 AM # ADSGoogle Adsense Advertisement
- Join Date
- Always
- Location
- Advertising world
- Posts
- Many
-
8th January 2021, 12:53 PM #2
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.
-
8th January 2021, 06:25 PM #3GOLD MEMBER
- Join Date
- Jun 2005
- Location
- Helensburgh
- Posts
- 7,696
Brett, as we discussed a while ago, have you tried it on another computer?
CHRIS
-
8th January 2021, 06:35 PM #4
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).
-
8th January 2021, 10:21 PM #5GOLD MEMBER
- Join Date
- Jun 2005
- Location
- Helensburgh
- Posts
- 7,696
I agree but nothing tried nothing gained.
CHRIS
-
8th January 2021, 10:42 PM #6
Djawannabe the guinea pig?
Similar Threads
-
DC motor behaviour
By Glenn.Visca in forum DUST EXTRACTIONReplies: 13Last Post: 6th August 2015, 11:24 AM -
Bizarre Timbers!
By Willy Nelson in forum WOODTURNING - PEN TURNINGReplies: 8Last Post: 29th March 2010, 09:07 AM -
Another bizarre eBay offering
By Mirboo in forum HAND TOOLS - UNPOWEREDReplies: 15Last Post: 8th October 2006, 10:03 PM -
Sum sing bizarre.
By Wongo in forum NOTHING AT ALL TO DO WITH WOODWORKReplies: 29Last Post: 3rd February 2006, 05:12 PM -
Bizarre Holidays - April
By oges in forum WOODIES JOKESReplies: 1Last Post: 2nd April 2001, 09:03 PM