what kind of black magic voodoo is excel playing with? (excel is randomly changing size & locations of activeX/OLEObjects)

kbishop94

Active Member
Joined
Dec 5, 2016
Messages
476
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
this has really stumped me and im at my wits end with trying to figure out whats triggering excel to do this exactly...(?)

So the last saved workbook and the main worksheet looks like this (the way it is supposed to be):
back to 2560x1440...its good again.JPG

But later, after closing it and then reopening it, excel thought for some reason that it would be funny to mess with me and change it all around and make it look like THIS:
AGAIN...WHYWHYWHYWHYW.JPG

or this (I guess as a way to show me that its not following any consistency or set rules and that its able to be deceptively creative and random when it wants to... 😈)
TM messed up.JPG


So after re-opening it and seeing that its all been scrambled & resized by excel (thank you very much!) , I find out that nothing I can do will return it back to its original appearance... aside from manually and one-by-one resizing & moving each and every object back to its original size and where it previously was located... which, suffice to say, would take forever and day.

But, I recently had a breakthough when I thought it might be related to resolution of the display from the last time when it was saved. So I experimented and re-saved it as a different name and after i changed the display's resolution with my display settings. Low and behold, when I save one of the "all jumbled up/rearranged objects" versions but when under a much lower resolution on the display settings, and then I closedthat workbook out and then re-setting the resoultion back to the original setting (which for me is 2560x1440), and THEN finally re-opening the workbook, vio-laa! its now back to being fixed(!) (but for the love of God why......????)

So what its not:

I dont think its anything related to this specific workbook. I also have a separate workbook that is completely different from this one, and the same thing happens to it occasionally too:
Here is what that one looks like before Bill Gate's evil tricks (this is what its supposed to look like):
before.JPG

and then what it looks like after microsoft's BS shapeshifting blackmagic:
messsed up again.JPG

Has anyone else ever ran into anything like this?

I'm glad that I have figured out a workaround for this issue (by changing the resoltuion on my display, saving it and closing it out, and then changing it back again), but the frequency that this is occurring (especially since its affecting two different workbooks that I used on a consistent basis for my job) is getting worse and more frequent and I would LOVE for someone to be able to tell me exactly what the root cause might be for this so hopefully I can apply/figure out a more permanent fix for absolutely frustrating problem...... 💡
 
Last edited by a moderator:

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
This is very very common and has been an issue for ages. The only real fix is not to use activex controls on worksheets. Stick to shapes and the forms controls section.
 
Upvote 0
This is very very common and has been an issue for ages. The only real fix is not to use activex controls on worksheets. Stick to shapes and the forms controls section.
So what triggers it? thanks
 
Upvote 0
Typically differing zoom levels/resolutions on screens. It’s often mentioned by users with a zoom level of >100% which are becoming increasingly typical with retina/hidpi screens. Exactly what causes it, I don’t know, but it does appear to be display related
 
Upvote 0
Typically differing zoom levels/resolutions on screens. It’s often mentioned by users with a zoom level of >100% which are becoming increasingly typical with retina/hidpi screens. Exactly what causes it, I don’t know, but it does appear to be display related
Now that is interesting.

I've been racking my brain trying to look at what changes that I've recently done that could attribute to the seemingly increase in this weird phenomena occurring. (Ive encountered it several times over the past several years, but never at the frequency that I have experienced in the last couple of 3-4 months.) The newest canidate for this annoying issue would be a new display I bought and started a couple months back. I rotate it back and forth from home and work. At home I use it primarily as a 2nd monitor to my mac as it has the same native resolution and size for it. At work I use it as 2nd monitor to my laptop. The other thing that has changed was that I recently (was forced to) upgraded to replace my beloved windows 7 to windows 10. That is (was) the leading canidate as far as my suspicions go to what is the likely cause in this happening of late (because I did this about a month to a month and a half before the new monitor and I think that thats when it started becoming more frequent.
BUT... I also changed the zoom for both of these workbooks to be at 130%(!) instead of 100%: 🤔
As a workbook open event I have both of them set with this line of code:

VBA Code:
ActiveWindow.Zoom = 130

And now that I think about it, I think that might align with my timeline of suspicions more accurately than anything else!!

I guess I have to look on the bright side of this whole situation which is that at least I stumbled upon a fix that has worked (so far!) every single time to bring it back to its original (object) settings after it goes all possessed on me.

Thanks for sharing that information about this.... going to try setting both workbooks back to 100% zoom for awhile and see if that makes it any better/worse. (y)
 
Upvote 0

Forum statistics

Threads
1,223,157
Messages
6,170,419
Members
452,325
Latest member
BlahQz

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top