problem with excel - missing images - deleting rows

Question

Hello! I am having a problem with excel.

I have an excel file with many product entries. Every product entry has a its own row, and in this row i have an image of the product.

My job is to update the quantities of the products, and after that I delete the rows of the products which are zero by using the filter.

Till now all this process had no problems.

But since last week, when i delete the rows with zeros, excel erases by itself all images from the first row with 0 qty to the last row, whether they have 0 or not.

This is a problem because i cannot delete one by one the rows of zero quantity. It takes much time, because the products are too many.

Please help!

Answer 1

I have been experiencing this same issue as well. When I delete multiple filtered rows of data that contain product images, when I unfilter the selection, images from the rows that were not deleted have been deleted. Can anyone please advise?? I noticed this issue just began a few weeks ago as well, so I suspect it is a bug.

Answer 2

Hello dear

I have the same issue as well

Did you get the solution for this?

Answer 3

Is there any other who can help?

Answer 4

Thank you Pakrashio

I've tried the way you suggested, but unfortunately it takes much time to delete all the hidden rows.

The selection was happening by clicking over the first row number, pressing shift at the same time, scroll at the end of the entries, and clicking over the number of the last row. After that I was deleting all the unnecessary rows. This way took me about 10sec. Now I' am waiting for the hidden rows to be deleted over 5 minutes. And I have to do it for 24 excel worksheets.

Is there a quicker way? Or can I fix it somehow (with your help) to work, as it worked before?

P.S Before this problem I had to upgrade from MS Office 2016 to MS Office 365. Could this be the reason this is happening?

It looks like the "Move and size with cells" property doesn't work as it should be.

Please help because it is essential for my job!

Thank you!

Answer 5

Hello sophiazotou,

You could try a different way of getting rid of the rows with zeros and see if it works out for you in this situation.

I am suggesting this because i cannot visualize how the selection for the entire data is happening when you select filter, especially because after a certain number of rows, the filter doe not usually give the correct result. I have seen this especially when i have data in more than 10k rows.

To use this, so a test run with a copy of your workbook because this has no undo.

under the file menu, under the "info" sub menu, you will see the option for Inspect Workbook.

Click on Check for Issues. Select the Inspect Document option. That will open the "Document Inspector" then Click on the "Inspect" button. a list of options will appear. While you scroll down the list of options, you will come across an option titled ‘Hidden Rows and Columns’. Select the “Remove All” option. this will permanently remove all the hidden rows.[ hence the need to work on a copy, just in case] Click on the ‘Close’ button. go back to the worksheet and remove all applied filters

With the above, what you will have hidden is rows with "ZERO" quantities. Try it and let me know how it goes.