I find working with Macros quite fun. I have automated many of my repetitive, manual and really really boring tasks with Excel VBA Macros. Once I got a task of copy-pasting more than 10,000 lines of items one-by-one from Excel to one of our ERP system and print these items. Usually, it would have taken me several days to finish this task but with macros, … Continue reading Two Easy Ways to Stop or Interrupt a Running Macro Command Without Closing Your Excel File?
Most of the time you may not need to cancel a command or interrupt your ongoing calculations in Excel as it carries out swiftly. But many times if you have got a very big file with lots of formulas and you have given a command or started any calculation say filtering any data then it may take a while to finish the action depending on … Continue reading Two Easy Ways to Cancel a Command or Interrupt Any Ongoing Calculations in Excel?
If you encounter this error while attempting to login too many times then you may have to wait for 10-20 minutes in order to get your login page back. It’s a hosting server specific error that prevents your website against hackers. Next time, when you get your login page back, try to reset your password and login again instead of trial and error. Continue reading WordPress “Unused” Error When Login Password Entered Incorrectly
I work with large data in spreadsheet and pivot table comes very handy in summarizing the data. However, often I encounter with an error when I try to group the multiple sets of date. Types of Pivot Table Date Grouping errors Pivot Table does not Group dates properly – It gets grouped into just one Group namely ‘Group 1.’ Sometimes it gives an error that … Continue reading Excel Error – Pivot Table Does Not Group Dates Properly or Give Errors
Lately, my Excel file started popping-up an error messages. It’s so annoying as it pops-up every time I save the file which I do like every 30 seconds. “Be careful parts of your document may include personal information that cannot be removed by the document inspector.” I fixed this error as below – Step 1 – Open your spreadsheet and go-to File Step 2 … Continue reading How to Fix – “Be careful parts of your document may include personal information” Error Message in Microsoft Excel
Many times we need to convert an URL to PDF, reasons might be different, the solution is pretty easy. You do not need any tool (if you Google, you will get many), you don’t need any software. This can be done right from your browser, see the process below. Open the URL you want to convert Now press Control+P (the one which is used for … Continue reading How to convert an URL/html to PDF?
There’s no doubt that the coming of cell phone spying app technology has made life so much easier. Business owners have a lesser risk of losing potential business opportunities if they keep their cell phones close. Moreover, now employers can keep track of the whereabouts of their employees and track their internet usage while they are at work, with the sole purpose of increasing productivity … Continue reading Is Cell Phone Monitoring Technology Worthwhile?
Are you looking for a way to download Pokemon Go on your Android or iOS phone in India? Since this game is only available in few countries and India not being one of them, you might get disappointed that you can’t play this game. Well, don’t get disappointing, here ‘s how you can download, install and play this game in India, both in iOS and … Continue reading How to Install and Play Pokemon Go in India
These days we tend to watch more videos on Facebook over Youtube. Mostly, they are shared by our friends or are related to our interest area. Many times, we come across videos that we would like to keep it for future use. One way of doing that is saving the link or sharing it in our own timeline. However, what if, we would like to share outside the … Continue reading How To Download Facebook Videos
In last post I mentioned about how to find if someone has blocked you on WhatsApp. Today, lets find out how to unblock yourself. It’s a simple trick that can come handy if you want to reach out to someone to clarify any sort of misunderstandings. Following steps will unblock you, if someone has blocked you – Go to WhatsApp settings Click account and then click on delete … Continue reading How To Unblock Yourself on WhatsApp If Someone Has Blocked You
Have you ever tried to find out if someone has blocked you in WhatsApp? I hope you don’t have to be in that situation. However, there are various indicators that may tell you that, you are blocked by someone: Firstly, you will not to see their ‘last seen’ or ‘online’ status. Also, you will no longer see any updates to their profile photo. You will always find same old photo. Moreover, if you try to … Continue reading How To Find If Someone Has Blocked You On WhatsApp?
This article will be very useful for people who work on excel and create a lot of reports and wants to create interactive excel graph. Often your clients or boss asks for details on a graph and then you have to go back and make changes and appear in front of them just to be asked for another change. Story Behind Interactive Excel Graph Very … Continue reading Interactive Excel Graph – How to create?