Hi everyone , any idea of what means this symbol ? I guess is making my Excel sluggish
bluebracket.png
Thanks
Hi everyone , any idea of what means this symbol ? I guess is making my Excel sluggish
bluebracket.png
Thanks
Hi, welcome to he forum
hard to say from a pic, can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
http://s000.tinyupload.com/index.php...23908718581168 here it is thanks , you can check in both sheets they are floating everywhere
Attach the workbook here, please.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
ok , done, uploaded thru that option
It appears that the author of the workbook inserted a drawing in the cell. The reason/rationale is unknown. I would urge you to talk to the author of the workbook and ask what meaning it has. It is not something that Excel has added automatically.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Something like 7000 of them across both sheets, I did run a quick count in vba but didn't make a note of the exact figures before running this.
You can use that to remove all of the shapes in the workbook, they appear to serve no practical purpose, but not knowing the reason for them being there, I would suggest following Alan's advice and check with the original author first.Please Login or Register to view this content.
Thank you. They are tine shapes. If you select one and drag it to make it bigger, you'll see. There are several of them in each 'pile'. Use Select Objects on the Find menu to get rid of them.
ok thanks , I'll run that code , because that seems to slow down Excel a lot and makes the whole workbook unusable, the author seem to have made it on mistake and he doesn't even know what he did, I'll delete all them , thank you guys
Ran the code for 2 hrs , deleted all shapes, file size went from 5 MB to 600KB only , can work back again thanks to all !
They are drawing objects which are totally useless as far as I can see.
Go to Find and Select, Special, Objects and then delete them.
Deleting the object reduced the file size from 199.6KB to 27KB
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks