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!
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!
> 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!
> (replace somewhere in email address with gmail if mailing direct)
> "Kenneth Ho" <ho...@hknet.com> wrote in message > news:e9f0c1$nd1$1@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!
> 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....@somewhere.com> wrote in > message:uvUZZFXqGHA.4...@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" <ho...@hknet.com> wrote in message > > news:e9f0c1$nd1$1@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!
> 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....@somewhere.com> wrote in > message:uvUZZFXqGHA.4...@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" <ho...@hknet.com> wrote in message > > news:e9f0c1$nd1$1@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!
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?
"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....@somewhere.com> wrote in > > message:uvUZZFXqGHA.4...@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" <ho...@hknet.com> wrote in message > > > news:e9f0c1$nd1$1@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!
> 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....@somewhere.com> wrote in > > > message:uvUZZFXqGHA.4...@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" <ho...@hknet.com> wrote in message > > > > news:e9f0c1$nd1$1@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!