←Back to all posts
•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Accidental duplication of pictures - how/why?

My company routinely uses an Excel shell document that is egregiously slow. Today I think I figured out why, but what I cant figure out is how.

The file is filled with 0.01”x0.01” pictures (see photo, at 400% zoom). The pictures are all transparent, even when enlarged there is nothing to show.

There must be 1000+ pictures in this file, judging by the size of the scroll box in the object pane. Also, they all have the same weird name: “ctl00_ctl00_CH_CH_ChangedGrid_ChangedGridGridView_IADD”.

I can attest that the people who manage this document are not tech savvy, and my company doesn’t allow Macros (there are workarounds but I doubt the people who manage this file could even stumble into VBA accidentally).

My question is, what are these pictures and how can there be hundreds to thousands of them?

submitted by /u/Broad_Remote499
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article→

Tagged with

#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#rows.com
#financial modeling with spreadsheets
#Accidental duplication
#Excel
#pictures
#Excel shell document
#transparent
#document management
#object pane
#0.01”x0.01”
#performance issues
#scroll box
#data redundancy
#file size
#weird naming
#file management
#VBA