|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Hello all,
I got a problem on my excel files. Hope you may help.
I don't know why, many of my excel files have a huge number of Text
Boxes. It's over 50,000 and they're all empty. As a result, it slows down
my computer. Whenever I edit the files, it takes more than 10 seconds to
move one cell to another. So, I can't do anything on them anymore.
I've checked my computer and it's no virus. I'm still using Excel 97.
Any one of you have the same experience? Why this happened? You will help
me a lot if you could solve my problem. Many thanks!
Regards,
Kenneth Ho
|
|
You don't know why?
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
"Kenneth Ho"
<hoken[ at ]hknet.com>
wrote in message
Hello all,
I got a problem on my excel files. Hope you may help.
I don't know why, many of my excel files have a huge number of Text
Boxes. It's over 50,000 and they're all empty. As a result, it slows down
my computer. Whenever I edit the files, it takes more than 10 seconds to
move one cell to another. So, I can't do anything on them anymore.
I've checked my computer and it's no virus. I'm still using Excel 97.
Any one of you have the same experience? Why this happened? You will help
me a lot if you could solve my problem. Many thanks!
Regards,
Kenneth Ho
|
|
If you remove them, do they come back?
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Kenneth Ho" <hoken[ at ]hknet.com> wrote in message
news:e9f0c1$nd1$1[ at ]nnews.pacific.net.hk...
[Quoted Text] > Hello all,
> I got a problem on my excel files. Hope you may help.
> I don't know why, many of my excel files have a huge number of Text
> Boxes. It's over 50,000 and they're all empty. As a result, it slows
down
> my computer. Whenever I edit the files, it takes more than 10 seconds to
> move one cell to another. So, I can't do anything on them anymore.
> I've checked my computer and it's no virus. I'm still using Excel 97.
> Any one of you have the same experience? Why this happened? You will
help
> me a lot if you could solve my problem. Many thanks!
>
> Regards,
> Kenneth Ho
>
>
|
|
Thanks for your reply.
I can't remove them all. As there're more than 50000. Any idea? Thanks.
Regards,
Kenneth Ho
"Bob Phillips" <bob.NGs[ at ]somewhere.com> wrote in
message:uvUZZFXqGHA.4684[ at ]TK2MSFTNGP05.phx.gbl...
[Quoted Text] > If you remove them, do they come back?
>
> --
> HTH
>
> Bob Phillips
>
> (replace somewhere in email address with gmail if mailing direct)
>
> "Kenneth Ho" <hoken[ at ]hknet.com> wrote in message
> news:e9f0c1$nd1$1[ at ]nnews.pacific.net.hk...
>> Hello all,
>> I got a problem on my excel files. Hope you may help.
>> I don't know why, many of my excel files have a huge number of Text
>> Boxes. It's over 50,000 and they're all empty. As a result, it slows
> down
>> my computer. Whenever I edit the files, it takes more than 10 seconds to
>> move one cell to another. So, I can't do anything on them anymore.
>> I've checked my computer and it's no virus. I'm still using Excel
>> 97.
>> Any one of you have the same experience? Why this happened? You will
> help
>> me a lot if you could solve my problem. Many thanks!
>>
>> Regards,
>> Kenneth Ho
>>
>>
>
>
|
|
You didn't answer Bob's question about if they come back.
But you could try a macro to remove the textboxes from the activesheet:
Option Explicit
Sub testem()
Dim myShape As Shape
Dim OLEObj As OLEObject
For Each myShape In ActiveSheet.Shapes
If myShape.Type = msoTextBox Then
myShape.Delete
End If
Next myShape
For Each OLEObj In ActiveSheet.OLEObjects
If TypeOf OLEObj.Object Is MSForms.TextBox Then
OLEObj.Delete
End If
Next OLEObj
End Sub
The top portion deletes the textboxes from the Drawing toolbar. The bottom
portion deletes the textboxes fom the control toolbox toolbar.
If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
Kenneth Ho wrote:
[Quoted Text] >
> Thanks for your reply.
> I can't remove them all. As there're more than 50000. Any idea? Thanks.
>
> Regards,
> Kenneth Ho
>
> "Bob Phillips" <bob.NGs[ at ]somewhere.com> wrote in
> message:uvUZZFXqGHA.4684[ at ]TK2MSFTNGP05.phx.gbl...
> > If you remove them, do they come back?
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (replace somewhere in email address with gmail if mailing direct)
> >
> > "Kenneth Ho" <hoken[ at ]hknet.com> wrote in message
> > news:e9f0c1$nd1$1[ at ]nnews.pacific.net.hk...
> >> Hello all,
> >> I got a problem on my excel files. Hope you may help.
> >> I don't know why, many of my excel files have a huge number of Text
> >> Boxes. It's over 50,000 and they're all empty. As a result, it slows
> > down
> >> my computer. Whenever I edit the files, it takes more than 10 seconds to
> >> move one cell to another. So, I can't do anything on them anymore.
> >> I've checked my computer and it's no virus. I'm still using Excel
> >> 97.
> >> Any one of you have the same experience? Why this happened? You will
> > help
> >> me a lot if you could solve my problem. Many thanks!
> >>
> >> Regards,
> >> Kenneth Ho
> >>
> >>
> >
> >
--
Dave Peterson
|
|
ps. it may take a little time to run with all those shapes.
Kenneth Ho wrote:
[Quoted Text] >
> Thanks for your reply.
> I can't remove them all. As there're more than 50000. Any idea? Thanks.
>
> Regards,
> Kenneth Ho
>
> "Bob Phillips" <bob.NGs[ at ]somewhere.com> wrote in
> message:uvUZZFXqGHA.4684[ at ]TK2MSFTNGP05.phx.gbl...
> > If you remove them, do they come back?
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (replace somewhere in email address with gmail if mailing direct)
> >
> > "Kenneth Ho" <hoken[ at ]hknet.com> wrote in message
> > news:e9f0c1$nd1$1[ at ]nnews.pacific.net.hk...
> >> Hello all,
> >> I got a problem on my excel files. Hope you may help.
> >> I don't know why, many of my excel files have a huge number of Text
> >> Boxes. It's over 50,000 and they're all empty. As a result, it slows
> > down
> >> my computer. Whenever I edit the files, it takes more than 10 seconds to
> >> move one cell to another. So, I can't do anything on them anymore.
> >> I've checked my computer and it's no virus. I'm still using Excel
> >> 97.
> >> Any one of you have the same experience? Why this happened? You will
> > help
> >> me a lot if you could solve my problem. Many thanks!
> >>
> >> Regards,
> >> Kenneth Ho
> >>
> >>
> >
> >
--
Dave Peterson
|
|
Hi Kenneth Ho,
did you manage to remove all this text boxes? i am having the same problem.
After starting a new file the problem started in this new one also. why tis
boxes are been created? any one knows? it can be an office update problem?
any ideas pls.
thank you
"Dave Peterson" wrote:
[Quoted Text] > ps. it may take a little time to run with all those shapes.
>
>
> Kenneth Ho wrote:
> >
> > Thanks for your reply.
> > I can't remove them all. As there're more than 50000. Any idea? Thanks.
> >
> > Regards,
> > Kenneth Ho
> >
> > "Bob Phillips" <bob.NGs[ at ]somewhere.com> wrote in
> > message:uvUZZFXqGHA.4684[ at ]TK2MSFTNGP05.phx.gbl...
> > > If you remove them, do they come back?
> > >
> > > --
> > > HTH
> > >
> > > Bob Phillips
> > >
> > > (replace somewhere in email address with gmail if mailing direct)
> > >
> > > "Kenneth Ho" <hoken[ at ]hknet.com> wrote in message
> > > news:e9f0c1$nd1$1[ at ]nnews.pacific.net.hk...
> > >> Hello all,
> > >> I got a problem on my excel files. Hope you may help.
> > >> I don't know why, many of my excel files have a huge number of Text
> > >> Boxes. It's over 50,000 and they're all empty. As a result, it slows
> > > down
> > >> my computer. Whenever I edit the files, it takes more than 10 seconds to
> > >> move one cell to another. So, I can't do anything on them anymore.
> > >> I've checked my computer and it's no virus. I'm still using Excel
> > >> 97.
> > >> Any one of you have the same experience? Why this happened? You will
> > > help
> > >> me a lot if you could solve my problem. Many thanks!
> > >>
> > >> Regards,
> > >> Kenneth Ho
> > >>
> > >>
> > >
> > >
>
> --
>
> Dave Peterson
>
|
|
I've never seen an office update do this. But there were suggestions in that
thread how to clean things up:
http://groups.google.co.uk/group/microsoft.public.excel/browse_frm/thread/f9ec25878c46765d/cdc03cdd5d65023a?lnk=st&q=&rnum=1&hl=en#cdc03cdd5d65023a
or
http://snipurl.com/wei0
Azim Lakha wrote:
[Quoted Text] >
> Hi Kenneth Ho,
>
> did you manage to remove all this text boxes? i am having the same problem.
> After starting a new file the problem started in this new one also. why tis
> boxes are been created? any one knows? it can be an office update problem?
>
> any ideas pls.
>
> thank you
>
> "Dave Peterson" wrote:
>
> > ps. it may take a little time to run with all those shapes.
> >
> >
> > Kenneth Ho wrote:
> > >
> > > Thanks for your reply.
> > > I can't remove them all. As there're more than 50000. Any idea? Thanks.
> > >
> > > Regards,
> > > Kenneth Ho
> > >
> > > "Bob Phillips" <bob.NGs[ at ]somewhere.com> wrote in
> > > message:uvUZZFXqGHA.4684[ at ]TK2MSFTNGP05.phx.gbl...
> > > > If you remove them, do they come back?
> > > >
> > > > --
> > > > HTH
> > > >
> > > > Bob Phillips
> > > >
> > > > (replace somewhere in email address with gmail if mailing direct)
> > > >
> > > > "Kenneth Ho" <hoken[ at ]hknet.com> wrote in message
> > > > news:e9f0c1$nd1$1[ at ]nnews.pacific.net.hk...
> > > >> Hello all,
> > > >> I got a problem on my excel files. Hope you may help.
> > > >> I don't know why, many of my excel files have a huge number of Text
> > > >> Boxes. It's over 50,000 and they're all empty. As a result, it slows
> > > > down
> > > >> my computer. Whenever I edit the files, it takes more than 10 seconds to
> > > >> move one cell to another. So, I can't do anything on them anymore.
> > > >> I've checked my computer and it's no virus. I'm still using Excel
> > > >> 97.
> > > >> Any one of you have the same experience? Why this happened? You will
> > > > help
> > > >> me a lot if you could solve my problem. Many thanks!
> > > >>
> > > >> Regards,
> > > >> Kenneth Ho
> > > >>
> > > >>
> > > >
> > > >
> >
> > --
> >
> > Dave Peterson
> >
--
Dave Peterson
|
|
|