TheLostBoy
Solid State Member
- Messages
- 17
I have an Excel 2007 workbook with lots of unwanted images & hyperlinks (3.71 mb - A1:M8851) saved in .xlsm format consisting of one worksheet into which I copied & pasted data from a webpage. Now, I cannot do anything without it freezing completely that involves formatting.
I tried a macro to remove all images which locked it completely. Then I ran a macro to remove hyperlinks, which again locked it up (I let it set overnight with no other programs running, hoping it was actually doing something).
Today, I tried just eliminating 2 columns I won't need (data only - no links or images) by selecting them up top & hitting Ctrl + '-' which froze it up again. I shut it down & opened it again (didn't let Excel recover it), then went into a column w/ no images or links & a very small amount of data & just hit "delete". It cleared the data pretty quickly, but I then selected just those rows in the column (rather than the entire column) and tried Ctrl+ '-', and it froze up again.
Any suggestions? I have data I need to add and work with in there, but all I'm trying to do now is get rid of the excess stuff I don't want or need so it'll run quicker without these problems.
I tried a macro to remove all images which locked it completely. Then I ran a macro to remove hyperlinks, which again locked it up (I let it set overnight with no other programs running, hoping it was actually doing something).
Today, I tried just eliminating 2 columns I won't need (data only - no links or images) by selecting them up top & hitting Ctrl + '-' which froze it up again. I shut it down & opened it again (didn't let Excel recover it), then went into a column w/ no images or links & a very small amount of data & just hit "delete". It cleared the data pretty quickly, but I then selected just those rows in the column (rather than the entire column) and tried Ctrl+ '-', and it froze up again.
Any suggestions? I have data I need to add and work with in there, but all I'm trying to do now is get rid of the excess stuff I don't want or need so it'll run quicker without these problems.