C
Christian Galbavy
Hello!
I think there is a general problem with excel. When I have several sheets
(over 20), and I want to rename a sheet, this takes about 30 seconds. I do
not know why and what is happening in the background, but it is a big
problem for my program. I use the "add" function to insert new sheets, and
the I use the "sheet.name" function to rename the inserted sheets. I have
more than 40 sheets in my workbook and as I said, the renaming-process takes
up to a minute.
When I insert a new sheet, my german excel version automatically names the
sheets like "Tabelle1", "Tabelle2", ...
Is there a function to set a certain name here, befor the insertion happens?
Or does anybody know, why the renaming function takes so much time?
Thanks for your help.
Regards
Christian Galbavy
I think there is a general problem with excel. When I have several sheets
(over 20), and I want to rename a sheet, this takes about 30 seconds. I do
not know why and what is happening in the background, but it is a big
problem for my program. I use the "add" function to insert new sheets, and
the I use the "sheet.name" function to rename the inserted sheets. I have
more than 40 sheets in my workbook and as I said, the renaming-process takes
up to a minute.
When I insert a new sheet, my german excel version automatically names the
sheets like "Tabelle1", "Tabelle2", ...
Is there a function to set a certain name here, befor the insertion happens?
Or does anybody know, why the renaming function takes so much time?
Thanks for your help.
Regards
Christian Galbavy