Latest Posts From Adnan Masruf
Today, we are going to discuss how to use the UBound function on a multidimensional array with VBA. This function is a very commonly used Array function in ...
Adnan Masruf
The image below shows an input box with a drop-down list of names. How to Launch VBA Macro Editor in Excel To run a VBA code, we first need to ...
In this article, we will discuss how to create Outlook folders from an Excel list. We use Outlook primarily for managing email messages, scheduling ...
In this article, we will show how to break a VBA loop with keyboard keys in Excel. Excel users often encounter infinite loops that run for an infinite time. ...
Today, we are going to discuss the TREND Function vs the FORECAST Function in Excel. We often need to predict the current and future patterns of a dataset. The ...
Here, we have the sales data of three different brands for two different products along the location of their stores. We will apply a single criterion and ...
Method 1 - Using Combo Chart Steps: Choose the D6 cell and enter, =$D$5 Press Enter. The cell will have the value in the D5 cell. ...
![[Fixed!] AutoComplete Not Working in Excel (2 Possible Solutions)](https://www.exceldemy.com/wp-content/uploads/2023/01/excel-autocomplete-not-working.png?v=1697455968)
In this article, we will deal with the issues when AutoComplete is not working in Excel. The AutoComplete is a very powerful feature of Excel. It allows users ...
Today, we are going to show how to turn on auto-calculate in Excel. When the auto calculate is turned on, Excel considers the changes made to a particular ...
Today, we will discuss how to use Auto Filter and Advanced Filter in Excel. The Auto Filter is the default filtering option in Excel. It allows users to filter ...
![[Fixed!] Null Error in Excel (3 Possible Solutions)](https://www.exceldemy.com/wp-content/uploads/2023/01/null-error-in-excel-.png?v=1697456497)
In this article, we will discuss reasons for #Null! Error in Excel and their possible solutions. #Null! The error occurs when we forget to use a comma or colon ...
We have the sales number of different stores of a product arranged in descending order. We will use this data to create the pipeline chart. Method 1 ...
Here are two simple ways to navigate worksheet tabs in Excel: To move to the adjacent sheet tabs, press Ctrl+PgDn to move to the next sheet, and press ...
Step 1: Setting up Hours, Minutes, and Seconds Click on cell C5 and enter the following formula: ...
Method 1 - Using PivotTable Options In this method, we will apply the PivotTable Options to clear the Pivot Cache. We will delete some of the data from the ...
- « Previous Page
- 1
- 2
- 3
- 4
- …
- 7
- Next Page »
See Our Reviews at
Dear Nirmal,
Could you please provide me with your Excel file that you have mentioned or some screen shots from your dataset? That would help me to understand your dataset and answer your query accordingly.
Thanks for your query.
Regards,
Adnan
Team ExcelDemy
Dear Raman,
1. First, make sure you are using MS Office 365 as they are only available in that version.
2. Secondly, make sure you are logged into your MS Excel account.
3. Thirdly, make sure to have the English, French, German, Italian, Spanish, or Portuguese editing language added to Office Language Preferences.
If these do not work then,
-Go to File > Options > Trust Center > Trust center Settings > External Content > Security settings for “Linked data types” > Activate “Enable all Linked Data Types”
or
– Go to Options>Customize Ribbon> All Commands
– Then, choose the Datatype Command
-Add the command to a “New Group”
-Finally, restart your Excel Application.
*Also, make sure to keep your internet connection ON; as this data type is linked datatype.
*You should also see if this datatype is available in your geopolitical locaton.
Dear K,
Thanks for your query. If we add replies to the comments (Like the first picture), we can find the replies by simply looking at the initials without changing the macros (Like the second picture)