Skip to main content
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Wednesday, 28 February 2018
  3 Replies
  7.1K Visits
0
Votes
Undo
Good day,

I am using the tool to combine 132 worksheets that contain 1 tab each, all named

I have checked the "Rename the tab" option, following these instructions https://www.extendoffice.com/product/kutools-for-excel/merge-excel-wordbooks.html:
https://www.screencast.com/t/Fc23xGfB
but it renames it to the current worksheet's tab (Sheet1) for each and every 132 new created tabs...
https://www.screencast.com/t/0VsNbZDdn0x


Is there something I'm doing wrong?
5 years ago
·
#1494
0
Votes
Undo
Hello,

May be the culprit is there are more than 31 characters for renaming the worksheet.
The Excel does not allow more than 31 characters for the worksheet name. :)

Thanks.
Should have been the name of the worksheets combined, such as: "Invoice #1268-C3 Mobile"
6 years ago
·
#1492
0
Votes
Undo
Hello,
What's the data for renaming the worksheets?
Thanks.
  • Page :
  • 1
There are no replies made for this post yet.