Reference Isn't Valid Excel Error and How to Solve It?

"Data source reference is not valid" is one annoying problem that can be hard to get rid of, if you don't know the source problem. In this article...

13 Methods of How to Speed Up Excel

Excel is fast enough to calculate 6.6 million formulas in 1 second in Ideal conditions with normal configuration PC. But sometimes we observe exce...

Why is My Excel File So Large? How to Reduce the Excel File Size?

Excel is an amazing tool for analyzing and visualizing  data sets. To visualize and make report we often need to save small chunks of data. These...

What to do If Excel Break Links Not Working

When we work with several excel files and use formula to get the work done, we intentionally or unintentionally create links between different fil...

Data validation with specific Hour, Minute or Second in excel

In this article, we will learn How to validate time entries which contain specific hours, specific minutes or specific time using data validation in...

Data validation with specific year, month, day or excel

In this article, we will learn How to validate date entries which contain specific year, specific month or specific date using data validation in ex...

How to use the MINUTE function in Excel

The Excel MINUTE function is a DATE & TIME function. This function takes time value as input and returns the MINUTE value from the input time va...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube