User Posts: Adnan Masruf
0
TREND vs FORECAST Function in Excel (3 Handy Examples)
0

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 ...

0
How to Use Combined MIN and IF Function in Excel (2 Easy Ways)
0

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 ...

0
How to Create Bar Chart with Target Line in Excel (3 Easy Ways)
0

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 ...

0
[Fixed!] AutoComplete Not Working in Excel (2 Possible Solutions)
0

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 ...

0
How to Turn on Auto Calculate in Excel (2 Easy Ways)
0

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 ...

0
How to Use Auto Filter and Advanced Filter in Excel
0

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 ...

0
[Fixed!] Null Error in Excel (3 Possible Solutions)
0

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 ...

0
How to Create Pipeline Chart in Excel (2 Easy Ways)
0

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 ...

0
How to Perform Tab Navigation in Excel (7 Effective Ways)
0

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. ...

0
How to Create Analog Clock in Excel (with Easy Steps)
0

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 ...

0
How to Clear Pivot Cache in Excel (3 Effective Ways)
0

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 ...

0
How to Calculate Uncertainty in Excel (3 Effective Ways)
0

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 ...

0
How to Add Tooltip to UDF in Excel
0

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 ...

0
How to Draw a Mohr Circle in Excel (with Effective Steps)
0

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 ...

0
How to Reset ComboBox to Default Value Using VBA
0

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 ...

Browsing All Comments By: Adnan Masruf
  1. 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

  2. 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.

  3. 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)

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo