Need help to fix a probable bug in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-3357630%22%20slang%3D%22fr-FR%22%3ENeed%20help%20to%20fix%20a%20probable%20bug%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3357630%22%20slang%3D%22fr-FR%22%3E%3CP%3EHi%2C%20I%20am%20having%20an%20issue%20only%20since%20few%20days%20with%20an%20Excel%20file.%20It%20also%20started%20with%20the%20computer%20of%20a%20colleague%20since%20mid-april.%3C%2FP%3E%3CP%3EHere%20is%20the%20(simplified)%20file%20%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.dropbox.com%2Fs%2Fw31td356tzmh0wp%2Fbug%2520excel.xlsx%3Fdl%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fwww.dropbox.com%2Fs%2Fw31td356tzmh0wp%2Fbug%2520excel.xlsx%3Fdl%3D0%3C%2FA%3E%3C%2FP%3E%3CP%3EWhen%20I%20delete%20a%20line%2C%20raw%2014%20for%20instance%2C%20some%20images%20below%20are%20resizing%2Freshaping%2C%20despite%20they%20are%20told%20to%20follow%20and%20reshape%20only%20according%20to%20their%20own%20cell%20(in%20their%20properties)!%3C%2FP%3E%3CP%3EMany%20persons%20are%20using%20this%20file%20since%20few%20years%2C%20and%20never%20such%20thing%20had%20happen.%3C%2FP%3E%3CP%3ESeems%20like%20it%20is%20a%20bug%2C%20because%20when%20I%20want%20to%20'undo'%20the%20deleting%20of%20the%20line%2C%20the%20images%20keep%20their%20bad%2Fugly%20shape%20and%20there%20is%20nothing%20I%20can%20do.%3C%2FP%3E%3CP%3EI%20feel%20like%20it%20is%20related%20to%20an%20update%20of%20Excel%2C%20or%20Windows...%20but%20I%20can't%20prove%20it.%3C%2FP%3E%3CP%3ECan%20anyone%20help%20me%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3357630%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3357735%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20to%20fix%20a%20probable%20bug%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3357735%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1387006%22%20target%3D%22_blank%22%3E%40Frederic_Schaeffer%3C%2FA%3E%26nbsp%3BThe%20pictures%20in%20your%20file%20are%20set%20to%20%22move%20and%20size%20with%20cells%22.%20So%2C%20when%20you%20delete%20a%20row%20underneath%20the%20picture%20it%20shrinks.%20You%20probably%20need%20to%20set%20them%20to%20%22move%20but%20don't%20size%20with%20cells%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3358554%22%20slang%3D%22fr-FR%22%3ERe%3A%20Need%20help%20to%20fix%20a%20probable%20bug%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3358554%22%20slang%3D%22fr-FR%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20answer.%3C%2FP%3E%3CP%3EAmong%20the%20things%20I%20tried%2C%20your%20proposal%20was%20into%20my%20scope.%20However%2C%20the%20result%20isn't%20good%20either.%20Some%20pictures%20aren't%20moving%20correctly!%3C%2FP%3E%3CP%3ESee%20by%20your-self%20in%20this%20second%20example%2C%20(I%20set%20all%20images%20to%20the%20properties%20that%20you%20propose)%20%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.dropbox.com%2Fs%2Fjci3a8yqbkojprf%2Fbug%2520excel%25202.xlsx%3Fdl%3D0%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.dropbox.com%2Fs%2Fjci3a8yqbkojprf%2Fbug%2520excel%25202.xlsx%3Fdl%3D0%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20actually%2C%20there%20are%20few%20reasons%20that%20makes%20me%20think%20that%20the%20problem%20is%20deeper%20%3A%3C%2FP%3E%3CP%3E1-%20the%20cells%20in%20each%20images%20are%20resized%20ARE%20NOT%20touch%20!%20I%20mean%20there%20is%20no%20reason%20for%20the%20image%20to%20resize%20!%20She%20should%20actualy%20move%20with%20the%20cell%3C%2FP%3E%3CP%3E2-%20this%20file%20worked%20for%20several%20years%20without%20problems..%20Why%20is%20this%20problem%20poping%20up%20now%2C%20while%20we%20haven't%20changed%20anything%20%3F%3C%2FP%3E%3CP%3E3-%20All%20images%20have%20the%20same%20properties.%20So%2C%20why%20some%20images%20are%20concerned%20by%20the%20problem%2C%20and%20some%20not%20%3F%20Looks%20weird%2C%20no%3F%3C%2FP%3E%3CP%3E4-%20Why%20my%20colleague%20had%20this%20problem%203%20weeks%20before%20me%2C%20while%20we%20were%20using%20the%20exact%20same%20file%20with%20the%20very%20same%20version%20of%20Excel%20(I%20checked%20the%20latest%20update%2Fversion).%3C%2FP%3E%3CP%3E5-%20having%20the%20properties%20not%20allowing%20resizing%2C%20but%20allowed%20to%20follow%20the%20cell%2C%20things%20aren't%20right%20anyway%2C%20because%20some%20images%20end%20where%20they%20shouldn't%20be%2C%20despite%20they%20should%20stay%20within%20their%20original%20cell!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELooking%20for%20help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3358636%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20to%20fix%20a%20probable%20bug%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3358636%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1387006%22%20target%3D%22_blank%22%3E%40Frederic_Schaeffer%3C%2FA%3E%26nbsp%3BSorry!%20I%20don't%20follow.%20All%20I%20see%20is%20that%20your%20file%20is%20inconsistently%20formatted.%20Most%20cells%20are%20merged%2C%20some%20are%20not.%20I%20add%2Fdelete%2Fresize%20rows%20and%20really%20can't%20replicate%20what%20you%20describe.%20You'll%20need%20to%20upload%20some%20screenshots%20with%20%22before%22%20and%20%22after%22%20to%20explain%20the%20problem.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3362778%22%20slang%3D%22fr-FR%22%3ERe%3A%20Need%20help%20to%20fix%20a%20probable%20bug%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3362778%22%20slang%3D%22fr-FR%22%3EHi%20Riny%2CI%3CBR%20%2F%3E%20wanted%20to%20do%20the%20screenshots%20for%20you%2C%20but%20the%20problem%20doesn't%20occur%20anymore%2C%20neither%20for%20me%2C%20neither%20for%20my%20colleages%2C%20neither%20the%20simplified%20file%2C%20and%20neither%20the%20real%20(complexe)%20file.%3CBR%20%2F%3EAs%20suspected%2C%20I%20strongly%20beleive%20the%20windows%20updates%20of%20yesterday%20overruled%20the%20ones%20of%20April%20that%20caused%20the%20problem.%3CBR%20%2F%3EWell%2C%20subject%20solved%20then%2C%20by%20itself!%3CBR%20%2F%3EThanks%20anymway%20for%20your%20help.%3CBR%20%2F%3EKind%20looks.%3C%2FLINGO-BODY%3E
New Contributor

Hi, I am having an issue only since few days with an Excel file. It also started with the computer of a colleague since mid-april.

Here is the (simplified) file :

https://www.dropbox.com/s/w31td356tzmh0wp/bug%20excel.xlsx?dl=0

When I delete a line, raw 14 for instance, some images below are resizing/reshaping, despite they are told to follow and reshape only according to their own cell (in their properties) !

Many persons are using this file since few years, and never such thing had happen.

Seems like it is a bug, because when I want to 'undo' the deleting of the line, the images keep their bad/ugly shape and there is nothing I can do.

I feel like it is related to an update of Excel, or Windows... but I can't prove it.

Can anyone help me ?

4 Replies

@Frederic_Schaeffer The pictures in your file are set to "move and size with cells". So, when you delete a row underneath the picture it shrinks. You probably need to set them to "move but don't size with cells".

 

 

@Riny_van_Eekelen 

 

Thanks for your answer.

Among the things I tried, your proposal was into my scope. However, the result isn't good either. Some pictures aren't moving correctly !

See by your-self in this second example, (I set all images to the properties that you propose) :

https://www.dropbox.com/s/jci3a8yqbkojprf/bug%20excel%202.xlsx?dl=0

 

And actually, there are few reasons that makes me think that the problem is deeper :

1- the cells, where each images are resized, ARE NOT TOUCHED ! I mean there is no reason for the images to resize ! They should actualy move with the cell

2- this file worked for several years without problems.. Why is this problem poping up now, while we haven't changed anything ?

3- All images have the same properties. So, why some images are concerned by the problem, and some not ? Looks weird, no ?

4- Why my colleague had this problem 3 weeks before me, while we were using the exact same file with the very same version of Excel (I checked the latest update/version).

5- having the properties not allowing resizing, but allowed to follow the cell, things aren't right anyway, because some images end where they shouldn't be, despite they should stay within their original cell !

 

Looking for help !

 

@Frederic_Schaeffer Sorry! I don't follow. All I see is that your file is inconsistently formatted. Most cells are merged, some are not. I add/delete/resize rows and really can't replicate what you describe. You'll need to upload some screenshots with "before" and "after" to explain the problem.

Hi Riny,
I wanted to do the screenshots for you, but the problem doesn't occur anymore, neither for me, neither for my colleages, neither the simplified file, and neither the real (complexe) file.
As suspected, I strongly beleive the windows updates of yesterday overruled the ones of April that caused the problem.
Well, subject solved then, by itself !
Thanks anymway for your help.
Kind regards.