Combine and rename tabs to the original Worksheet
By mhardy@crakmedia.com on Wednesday, 28 February 2018
Posted in Kutools for Excel
Replies 3
Likes 0
Views 7.5K
Votes 0
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?
Hello,
What's the data for renaming the worksheets?
Thanks.
qiuhongkun
·
6 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
Should have been the name of the worksheets combined, such as: "Invoice #1268-C3 Mobile"
mhardy@crakmedia.com
·
6 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
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.
qiuhongkun
·
6 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post