·
3 years ago
Please help to convert the 22.1.2018 to 22-jan-2018
Kutools for Excel：強大的Excel工具箱
Kutools for Excel 是功能強大的Excel工具箱，可讓您免於在Excel中執行耗時的操作。 該工具箱具有適用於Excel 300、2019、2016、2013、2010和Office 2007的365多種強大功能。
| 最新更新： Kutools for Excel 25.00 日期：08 年 2021 月 XNUMX 日 |
我們歡迎所有問題，反饋和錯誤報告。 我們通常需要以下信息： 聯絡我們
|
|
訂閱時事通訊： |
Kutools for Excel功能教程：
您可以通過在以下搜索框中輸入功能名稱來快速訪問功能教程。 例如，如果您想知道如何使用 閱讀版式視圖，您只需要輸入 閱讀 搜索框中的關鍵字。
You are guest
or post as a guest, but your post won't be published automatically.
Loading comment...
The comment will be refreshed after 00:00.
-
To post as a guest, your comment is unpublished.
-
To post as a guest, your comment is unpublished.Please don't post any comments after this article. We will not answer it. Please use the forum
https://www.extendoffice.com/forum/kutools-for-excel.html or contact us with email. -
To post as a guest, your comment is unpublished.I am trying out your Excel plugin. To test, I deliberately copied data in 2 cells from 1 range and pasted them exactly into another range on a sheet in the same workbook, then used your 'compare cells' tool and it does not find a match. Repeated test many times. Not sure if its working for others, but definitely not for me. Will not be purchasing. Excel 2010 on Windows 10 PC.
-
To post as a guest, your comment is unpublished.Hello,
Once again, please don't post any comments after this article. We will not answer it. Please use the forum or contact us with email.
BTW, it work, please take a look at https://www.extendoffice.com/product/kutools-for-excel/excel-compare-ranges,-rows-and-columns.html
-
-
To post as a guest, your comment is unpublished.Hello
when I downloaded Kutools for excel I saw that it can be usable for 45 days trial But when I installed it a window with license and purchase appeared please give me the answer I want to try some issues and buy the license later.
Thanks -
To post as a guest, your comment is unpublished.I am trying out your software in excel and using the To Actual button.
i don't know if there is a limit to the amount of cells it can change at one time but i was trying it out on 13755 cells and i get most of them converted but about 1200 to 1500 of them convert to #Ref.
Let me know what you think. -
To post as a guest, your comment is unpublished.how to use excel files with this software
-
To post as a guest, your comment is unpublished.I am using the reading layout and cannot edit comments in this mode, I can delete them and create them just not edit which is a pain having to rewrite the whole comment. It is a large spreadsheet W columns and 5800 rows so far with the W column holding extensive comments on each record.
-
To post as a guest, your comment is unpublished.In Excel, I have business names list in one sheet and its outwit export contact data(sheet2)(address, Page title,business url,Source url...) but it does not contain business name. So, I want to add business name column to its businessurl in sheet2. I have large no of records in excel sheet.
For ex:
In sheet1: In sheet2:
abc www.wh.com
xyz www.xy.com
White House www.abc.com
1) how I will get business urls name to its adjecent column.
2) how can I check business name from its url. -
To post as a guest, your comment is unpublished.
-
To post as a guest, your comment is unpublished.Can anyone guide me how to buy this?
https://www.extendoffice.com/order/kutools-for-excel.html -
To post as a guest, your comment is unpublished.Hi. installed free version to test and evaluate before purchasing. Problem is KUTOOLS don't show on my ribbon, no idea why. After installation I was prompted to start Excel, which I did, then, closed it and now KUTOOLS doesn't show. Any idea why?
-
To post as a guest, your comment is unpublished.Hello,
Please don't post such issue after this article.
Please contact us via jaychivo@extendoffice.com with the detailed information.
Please go to check your Excel add-ins manager. Can you see the Kutools for Excel in your Excel add-ins manager?
Please try to enable both Kutools for Excel add-ins in your Excel add-ins manager.
Thanks in advance.
-
-
To post as a guest, your comment is unpublished.
-
To post as a guest, your comment is unpublished.
-
To post as a guest, your comment is unpublished.Good Morning: I have purchased a license for Kutools for all MS products after successfully using the free version for excel. I loved the addin; however, since purchase NONE of the plugins work- in fact, if I attempt to use any function of the add-in my program, anyone that I'm using, crashes. This was a considerable investment and yet I have less access than I did when I was using a free version for excel.
-
To post as a guest, your comment is unpublished.Hello,
Please don't post such topic here. If you want to get the support quickly, please contact us via jaychivo@extendoffice.com or post the topic in the forum section.
-
-
To post as a guest, your comment is unpublished.Hi, I have multi Excel file with data like
YES
YES
YES
YES
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
can I change like 50% of NO to YES using VBA? How? thanks-
To post as a guest, your comment is unpublished.Hello,
Please use the forum for help.
-
-
To post as a guest, your comment is unpublished.
-
To post as a guest, your comment is unpublished.
-
To post as a guest, your comment is unpublished.Hi can i get freeware version of Kutool (may be limited options) for long term?
-
To post as a guest, your comment is unpublished.Can my license name and code be emailed to me?
-
To post as a guest, your comment is unpublished.Hello,
Please try to contact us via jaychivo@extendoffice.com with your order information.
-
-
To post as a guest, your comment is unpublished.
-
To post as a guest, your comment is unpublished.I am looking for previous versions of Kutools for excel but all links lead to V16.5. My licence expired in July. Please assist...
-
To post as a guest, your comment is unpublished.Hello,
You can install the old version from https://www.extendoffice.com/downloads/History-Kutools-for-Excel/16.00/KutoolsforExcelSetup.exe
You can contact us with your order information via jaychivo@extendoffice.com.
-
-
To post as a guest, your comment is unpublished.I have a problem with Work Area utility.
When I use it at work with two displays attached to my laptop, the pop up panel with the 4 profile buttons shows up correctly
Instead, when I use the same at home on the same laptop without additional screen, the pop up does not show up correctly (see attachment).
I already tried changing scaling and resolution settings, but nothing changed.-
To post as a guest, your comment is unpublished.Hello All,
Please try to use the forum to post your issue or feedback https://www.extendoffice.com/forum/kutools-for-excel.html
Or please send an email to jaychivo@extendoffice.com.
Please don't post your issue after this article.
1. Please make sure you have installed the latest version.
2. Please tell me the version informaiton of your Office and computer system.
Thanks in advance.
-
-
To post as a guest, your comment is unpublished.Hi,
I just purchased the Kutools for excel. How do I activate it ? -
To post as a guest, your comment is unpublished.Hi I am Jotham. I have purchased a single license user software but when I try to update it refuses to work. What would be the issue?
-
To post as a guest, your comment is unpublished.Will this product work on Excel 2016 64bit Office 2016?
-
To post as a guest, your comment is unpublished.Yes, this software is compatible with the Microsoft Office 2007 / 2010 / 2013 / 2016 / Office 365, 32 bit or 64 bit of all series. (ok)
Please go to have a 60-day free trial from https://www.extendoffice.com/downloads/KutoolsforExcelSetup.exe.
-
-
To post as a guest, your comment is unpublished.Hi, I am trying the trial version of Kutools to insert multiple pictures matching with their names. I followed every step described in the website, but the image still comes out from the image sequences instead of matched names image. Any idea what goes wrong?
-
To post as a guest, your comment is unpublished.Please try to contact me via jaychivo@extendoffice.com.
Please try to show how to replicate your operation.
Thanks in advance.
-
-
To post as a guest, your comment is unpublished.I emailed as I ordered this and my computer got messed up and when I went to reload it I couldnt
-
To post as a guest, your comment is unpublished.Hello,
Please try to contact me with your order informaiton via jaychivo@extendoffice.com.
Please be more specific about your issue.
Thanks in advance.
-
-
To post as a guest, your comment is unpublished.When I try to combine worksheets it either doesn't combine in the file when I open it or says that I have exceeded the size (in which case, I do not have that much data)
-
To post as a guest, your comment is unpublished.Please try to create some sample data in a new workbook and try it again.
If the problem persists with the sample workbook, pleas send the workbook to us via jaychivo@extendoffice.com.
Please be more specific about your operations.
-
-
To post as a guest, your comment is unpublished.HI,
I downloaded the trial version to see if we should purchase. I used the advanced combine rows but after my data refreshes, they go back to uncombined. Is there a way to make them stay combined (or recombine)? Others will be using this workbook and they don't have the add-in.
Thanks-
To post as a guest, your comment is unpublished.Please try to create some sample data in a new workbook and try it again.
If the problem persists with the sample workbook, pleas send the workbook to us via jaychivo@extendoffice.com.
Please be more specific about your operations.
-
-
To post as a guest, your comment is unpublished.Hi, I was sent email to Jay Chivo but he not reply my email for more than 20 hours.
I have problem to use Kutool Excel after purchase and when in open excel and try to use Kutool and Enterprise but excel shut down after click. Even I create new excel file but it's also the same. Delete, Download and install it's still same.-
To post as a guest, your comment is unpublished.
-
To post as a guest, your comment is unpublished.I am having the same problem too. I am using Excel 2013... :( Did you get any fix for this?
-
-
To post as a guest, your comment is unpublished.Hi,
We just started a trial version yesterday & heavily used the 'Advanced Combine option' yesterday without issue. Today I'm having to submit the combine request twice before the function works.
Windows 10 running Excel 2016
Thank you-
To post as a guest, your comment is unpublished.[quote name="Tracy Colegrove"]Hi,
We just started a trial version yesterday & heavily used the 'Advanced Combine option' yesterday without issue. Today I'm having to submit the combine request twice before the function works.
Windows 10 running Excel 2016
Thank you[/quote]
Can you get it done? If no, please try to contact us with the detailed information via jaychivo@extendoffice.com
-
-
To post as a guest, your comment is unpublished.Hi,
I love this product. Do you have a portable version that i could use at work?
Thank You,
Steve :-) -
To post as a guest, your comment is unpublished.Hi,
I have a pivot table with multiple row fields wherein i have to look for a specific value. Is it possible to use Kutools and get data for these multiple row fields. I have mentioned an example below-
Status Count
Closed --- 2
Dev ---- 1
Live ----- 1
Open ----- 5
Test ---- 3
Live ----- 1
Dev ----- 1
In this case if we want to count total number of defects that were raised in Dev Environment then ideally the count should be 2 [ Closed-1+Open-1]. So can you please confirm if it is possible to calculate the total count using Lookup formula of Kutools. If yes, can you please assist on how this can be done ? -
To post as a guest, your comment is unpublished.Hello, I accidentally moved the Kutools folders when I was trying to clean up my documents on the computer and now whenever I open excel I get the error message that reads "Access violation at address 07ED2750 in module 'PANEFO~1.DLL', Read of address 000000000" and when excel opens, the words in the navigation pane are not in English. How do I resolve?
-
To post as a guest, your comment is unpublished.[quote name="Andrew"]Hello, I accidentally moved the Kutools folders when I was trying to clean up my documents on the computer and now whenever I open excel I get the error message that reads "Access violation at address 07ED2750 in module 'PANEFO~1.DLL', Read of address 000000000" and when excel opens, the words in the navigation pane are not in English. How do I resolve?[/quote]
Please try to reinstall the software. If the problem persists after installation, please contact me via jaychivo@extendoffice.com.
-
-
To post as a guest, your comment is unpublished.Hi Admin
i use your kutools a lot but currently we only use your very old version 5. We tried 6 but you changed the way photos are imported therefore you kindly helped us revert back to the old version.
My new laptop will not open up the user interface big enough for me to actually select the option the photos and the sizes therefore can no longer continue to use this version. I have seen the newest version is 16 so it has come a long way over the past few years. the newer version isn't as good as the older one with regards to the importing of the photos. but it is useable :)
please can someone contact me via my email address so i can call someone to explain what it is i am trying to do to see if i have missed the function. I end up getting duplicate photos at the end.
Thank you for your help.-
To post as a guest, your comment is unpublished.[quote name="tom"]Hi Admin
i use your kutools a lot but currently we only use your very old version 5. We tried 6 but you changed the way photos are imported therefore you kindly helped us revert back to the old version.
My new laptop will not open up the user interface big enough for me to actually select the option the photos and the sizes therefore can no longer continue to use this version. I have seen the newest version is 16 so it has come a long way over the past few years. the newer version isn't as good as the older one with regards to the importing of the photos. but it is useable :)
please can someone contact me via my email address so i can call someone to explain what it is i am trying to do to see if i have missed the function. I end up getting duplicate photos at the end.
Thank you for your help.[/quote]
Please contact us via jaychivo@extendoffice.com
-
-
To post as a guest, your comment is unpublished.Hello
I just installed the software and used your free trial and loved it.
Im trying to split the data into multiple worksheets and im only getting the new tabs and the header.. no data
didnt have this problem in the free trial version.
How do I resolve?
big project due Monday.. please help-
To post as a guest, your comment is unpublished.[quote name="Leasha Riggs"]Hello
I just installed the software and used your free trial and loved it.
Im trying to split the data into multiple worksheets and im only getting the new tabs and the header.. no data
didnt have this problem in the free trial version.
How do I resolve?
big project due Monday.. please help[/quote]
Please try to create some sample data in new workbook and try it again.
If the problem persists with the sample workbook, please contact me via jaychivo@extendoffice.com.
Please attach the sample workbook in your email.
-
-
To post as a guest, your comment is unpublished.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! -
To post as a guest, your comment is unpublished.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
-
To post as a guest, your comment is unpublished.[quote name="Ajaz"]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[/quote]
Please try to use this formula: =IF(SUM(INDIRECT("B1"))>=$C$1,"",A2)
-
-
To post as a guest, your comment is unpublished.
-
To post as a guest, your comment is unpublished.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!
-
To post as a guest, your comment is unpublished.[quote name="Jenny"]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![/quote]
Please try to contact us with your order informaiton. You can contact me via jaychivo@extendoffice.com. :-)
We will solve it for you.
-
-
To post as a guest, your comment is unpublished.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-
To post as a guest, your comment is unpublished.[quote name="marco"]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[/quote]
Please try to contact us with your order information via jaychivo@extendoffice.com.
We will solve it for you. :-)
-
-
To post as a guest, your comment is unpublished.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-
To post as a guest, your comment is unpublished.[quote name="I N"]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[/quote]
Please try to contact us via jaychivo@extendoffice.com with detailed information about the issue.
-
-
To post as a guest, your comment is unpublished.I need my registration code and I submitted the form and have not received the email Can you help?
-
To post as a guest, your comment is unpublished.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!
-
To post as a guest, your comment is unpublished.[quote name="Nikosjc"]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![/quote]
Hello, you should try: https://www.extendoffice.com/product/kutools-for-excel/excel-insert-multiple-pictures.html-
To post as a guest, your comment is unpublished.[quote name="admin_jay"][quote name="Nikosjc"]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![/quote]
Hello, you should try: https://www.extendoffice.com/product/kutools-for-excel/excel-insert-multiple-pictures.html[/quote]
Hi, Im' sorry but this link doesn't answer in my question. I am using "match import pictures", but as you can see in photo from the bellow link, it load only the first photo with the same name/path and nothing else. Any solution for this please? Thanks.
https://www.dropbox.com/s/zhsp0h0y0oe2ert/example.jpg?dl=0
-
-
-
To post as a guest, your comment is unpublished.Do you have a version of the range swap that only swaps the contents of the cells and not the formatting?
-
To post as a guest, your comment is unpublished.
-
To post as a guest, your comment is unpublished.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-
To post as a guest, your comment is unpublished.[quote name="Mark Grosart"]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 > Sorry, we don't have such function.
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? >> They don't need to install the Kutools for Excel.
Thanks[/quote]
1. Is this possible > Sorry, we don't have such function.
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? >> They don't need to install the Kutools for Excel.
-
-
To post as a guest, your comment is unpublished.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?-
To post as a guest, your comment is unpublished.[quote name="Sayb Sourchi"]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?[/quote]
Please try to contact me via jaychivo@extendoffice.com with your order information. We will fix it for you.
-
-
To post as a guest, your comment is unpublished.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?
-
To post as a guest, your comment is unpublished.
-
-
To post as a guest, your comment is unpublished.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!-
To post as a guest, your comment is unpublished.[quote name="Sam"]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![/quote]
This is very special issue. We will try to fix it in upcoming versions. It only happens under certain circumstance. :sad:
-