Fantastic plugin!
I am having one odd issue that maybe you could help with.
I have a sheet with data out to column w and almost 12,000 rows. I am splitting the data by a value of one of the columns and naming the sheets after the name of the data in those columns and it ALMOST works perfectly. Its splitting out all the data as it should into the properly named new sheets, but what is happening is I am getting about 30 sheets not named properly and named as the default sheet name. Those sheets have the data they should, but are just not taking the name of the column values like all the others. Is this just too big of an operation and it is having errors, or is there something I could do to the master sheet to help fix what may be happening because it seems to be the same data groups doing it each time.
Thank you!

Dear, i have values in a range of cell, say fromA1: A100. In another cell C1 i have value 200. Now i will start adding A1 with A2 if the result value is less than C1 i will again add A1 to A3 if the sum is less than C1 i will again add A1:A4 and so on untill the sum is more or equal to C1. How can i do that

I just wish to find sum of best of two questions using a single formula in total column

Since I purchased this software it never worked for me, every time I try to do something with kutools it always frozen my excel, it is horrible and I can not get any support from the kutools team. Very disappointing!

I had problem to register the product (Kutools for excel) but after having solved this issue I can't use the tools becuase every time I' trying to use a Kutools task the Excel closed.
Please help me
Thanks

Marco

Hello, I am using the file list function and finding that Kutools can only import 32,767 lines of data. Why is this the case and is there a way to generate the file list with more than 32,767 rows?

Also, I am finding that after a few uses of this function, Kutools and my other add-ins disappear. Is there a way to fix this?

Thank you,
I N

I need my registration code and I submitted the form and have not received the email Can you help?

Hi, I am using the "match import pictures" and works fine if I have unique names/path in the cells and unique photos. But I would like to import a photo more than one time if there is the same name/path in the path column. Is this possible? Thanks!

Do you have a version of the range swap that only swaps the contents of the cells and not the formatting?

I use a Mac machine and have installed Microsoft Office 2007 on it, running under Crossover virtual machine. I have also installed Kutool on the virtual machine, but how do I get excel to work with Kutools?

Hi - I'd like to use Kutools for Excel to prepare worksheets my customer can upload images to
The display of the images needs to be constrained to the cell, but when downloaded the full image downloads
1. Is this possible
2. I intend to use this for a large number of customers - do they all need to buy Kutools, or can I prepare a worksheet they complete?
Thanks

I have just installed this tool for Excel 2016, I have registered the product but cant use it at all.

everytime I try a function the excel sheet, shuts down and closes, I have tried to restart the computer, uninstall and reinstall and re-register the license code but no go.
can anyone help. do these guys have a support phone?

Hi - I have purchased license but i have not got any license code. I also checked my spam folder. Where will i get the code?

I installed "Kutools For Excel 16.00" in Win10,and selected language Chinese,but when I open Excel2016 the language is still English,and there is no item in language lists(Help>Languages).the language folder (C:\Users\Public\Documents\Kutools for Excel\Languages) has many languages such as 简体中文[SimpChinese],Dansk[Danish] etc.
Can you tell me what's the problem?
Any help would be great!

If I buy a license, do I get free updates to the software?

I have requested 2 separate times for license retrieval and I have received no response. Is there a way to escalate this issue?

I'm working on Solid Edge files with embedded excel files but when I try to edit an embedded excel file the active cell jumps from the embedded file to a separate excel workbook I have open. Can you tell me how to stop this?

So i have this file with numbers in column n B and an image path in column I.
What I want to do is have the files in column I rename themselves to the files in column B

example column b is 34567 , column I is some image URL bit I want the name of the image to match the newly formed column which in a perfect world would download all files and rename this file to 34567.jog and save all files in one folder after being renamed.

Any help would be great!
Adam

There is an error in the calculations when using the "Operation / Multiplication" function. It rounds to 2 if you select a column and if you do multiple selections (holding the Ctrl Key) it miscalculates all of the fields after the initial area selected. This function worked fine about two upgrades ago. Having to use ASAP Tools right now, but prefer Kutools when it worked.

Hi,
I am using KU Tool for excel for import of image and matching them with JPEG files in Desktop. However it does not skip pictures of images not found in the folder.

I noticed that when I protect worksheets, opening them in other computers will not permit to do simple formatting, such as freeze panes, the entire ribbon is greyed out, well most of it.

Hi,

Can I call Kutools commandos in my VBA modules.
Something like :
call kutools_commando

Thanks,

Yves

Hello,

I'm running both Excel 2010 and 2013. I'm trying to view two workbooks side by side. The option is available in 2010, but not in 2013. Is there a setting that I have to set in 2013?

I'm running Windows 7, Office 2010 & Office 365.

Thanks,

Hi, is it possible to conbine a .xlsx workbook into a .xlsm workbook?
Thanks
Peter

How do you protect formulas? I did a Protect Worksheet but then it wouldn't allow any data entry into non-formula cells.

Hi. I have just installed this tool today. It successfully installed and the kutools tab appears but it's not working. Whenever I click on any function tab inside the tool, a small error window shows up.

Hi:

I have 50 worksheets with a piece of data in A42 on each spreadsheet. How do I use KU Tools to get the piece of data on A42 from all of my worksheets to show up on one page?

It is really helpful.
Thanks

I'm not sure if Kutools will do this for me but I need a utility to expand cell contents containing a range indicated by a hyphen. Cell contents would be for example "7-11". For vertically represented columns the utility would expand the "7-11" so that "7", "8", "9", "10" and "11" would each be in a single cell in a column.

Hi can you help please.
I am trying to use the "fill worksheet references" tool. But it will not fill with a subtotal value that is calculated from a sheet. What do I need to do to overcome this issue? Thanks. E.g
Worksheet 1
A B C D
Item quantity x rate = total
Insulation 50 £2.50 £125.00
Insulation 50 £2.50 £125.00
Insulation 50 £2.50 £125.00
Insulation 50 £2.50 £125.00
Subtotal £500.00 (I want this cell total to auto fill list from each sheet on to the master sheet) e.g
Work sheet 1 - £500.00
work sheet 2 - £750.00
work sheet 3 - £750.00

If I purchase and install will functionality only work on my computer that I would like other to see after everything has been calculated?

I see there is an option to change range name to their corresponding cell references. Is there a way to change cell references, i.e.A1,A2 etc. to their corresponding names i.e, REV_WK_TOT etc. in formulae. I have a horizontal row of cells containing formulae using cell references. I later created unique names for each cell and want to convert all the cell references to their names. I have several thousand formulae to convert
Kind regards in advance
Alan

Hi i have a spanish excel file.
My requirement is to translate the complete content to english.
Right now i couldnt see any translation option.Please advice.

How to auto increment after x amount of rows using kutool?

example:
A B
1 1 3
2
3
4 3
5 6
6
7 5
8
9 9
10 7

In A column I have incremented with the interval of 2rows and in B column 3rows.

How to do with Kutools?


Thanks!

on the enterprise /combine tab, is it possible to edit a saved scenario, for the addition of an extra worksheet rather than have to type everything in again? Excel 2013

I have a field with data to separate into three different fields.

Last Name, First Name, Middle Initial (all in one)

Some records no not have middle initial.

Does anyone know if I can do it using this great tool?

Thanks,
C. Manzano

I need to use the format tools function for all cells in a workbook. I have 40 spreadsheets. Can the formatting - including cell width be copied?

Hi Am using the Kutools Content Converter > Advanced Combined Rows> Key Column (A) - B to H Combined Operations > Only Combine with Separator > New Line. When the function has finished most dates within the columns convert to US dates (want UK dates i.e. 18/09/2014 (18th September 2014). Using the Date Conversion function appears not to apply anything at all.

Any ideas what the problem may be?? Please advice

I'm trying to get a list of exe files from a directory but I get this message :"There are more than 10000 files in the directory , please specify other directory. "

Is there any other way to get the list of files ?

I have installed my registered version on a system which requires Admin access for updating/installing. I do not wish to bother my Admin every time I update the software. Any solution?

I wish that: [b]Workbook Split window should have[/b
(1) facility to organise worksheet names alphabatically or as displayed in workbook.
(2)facility to Select All/Deselect All Worksheet. (it becomes difficult to select a single worksheet from many withing a Workbook.

Hi, I'm trying to batch convert my xls files to pdf using the file format converter option, but even after adding the files that require to be converted and I press okay, the screen remains there without converting any files. Please assist.

Hello, please uninstall the software from Control Panel.

and to reinstall the software by using EXE installation package.

[b]whenever i click on text tools on Kutools Menu it says Kutools for excel is loading and no window opens as shown in help.please let me know[/b]

I still have not figured out what this is supposed to do. Got any ideas?

Hi there - I love the add-in but wanted to know why the navigation pane opens up every time I open an excel file. I'd like to opt in manually rather than have it open up every time. Is there a way to manually activate so it doesn't open up by default?

I am leaving the company I am with and Kutools is installed on their computer. Can you remove it from their computer and I reinstall it on the computer at my new compnay-for free? Keeping the same license?

Please please pleeeeease make a version that runs on OSX, I would buy all of your products and love you forever. Seriously though, this is a great excel add-in, even if you know formulas/macros to do everything, kutools makes it so much faster and easier.

Is there is a version of this plugin for use on Macs?

c