Today, we are going to discuss the TREND Function vs the FORECAST Function in Excel. We often need to predict the current and future pattern of a dataset. The ...
Today, we are going to discuss the use of the MIN and IF function in Excel. We will use the MIN and IF functions together to find the minimum value from a list ...
Today, we are going to show you how to create a Bar Chart with a target line in Excel. A target line is a line depicting the goal of a project. By inserting a ...
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 ...
Woday, 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 ...
In this article, we will discuss reasons for Null Error in Excel and their possible solutions. Null Error occurs when we forget to use a comma or colon in ...
Today, we are going to show two ways to create a Pipeline chart in Excel. Pipeline charts depict the values of a certain parameter or process in a decreasing ...
In this article, we will show multiple ways to perform Tab Navigation in Excel. Users often need to switch between worksheets while working in a workbook. ...
Today we will show how to create an Analog Clock in Excel. Analog Clocks are clocks that contain hour, minute and second hands and give time in a 12-hour ...
In this article, we will discuss how to clear Pivot Cache in Excel. Pivot Cache is a replica of the source data that Excel creates as soon as the PivotTable is ...
Today, we will show how to calculate uncertainty in Excel. Uncertainty is a part of any random dataset. It is often referred to the doubt surrounding the ...
Today we will talk about ways to add Tooltip to UDF or User Defined Function in Excel. Tooltips are small descriptions of functions when we enter the function ...
Today, we will show how to draw a Mohr Circle in Excel. The Mohr’s Circle is a powerful engineering visualization tool. It is a sophisticated way to visualize ...
In this article, we will show how to reset ComboBox to default value using VBA code. ComboBoxes are a great tool to store a list and then select from to ...
- 1
- 2
- 3
- …
- 6
- Next Page »
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)