Note: The other languages of the website are Google-translated. Back to English
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
  4.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?
4 years ago
·
#1492
0
Votes
Undo
Hello,
What's the data for renaming the worksheets?
Thanks.
0
Votes
Undo
Should have been the name of the worksheets combined, such as: "Invoice #1268-C3 Mobile"
4 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.
  • Page :
  • 1
There are no replies made for this post yet.

Follow Us

Copyright © 2009 - www.extendoffice.com. | All rights reserved. Powered by ExtendOffice. | Sitemap
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Protected by Sectigo SSL