Ragavan Rajan

I'm Ragavan Rajan - Lead Business Improvement, Innovation & Development, having professional experience in SharePoint 2010 / SharePoint 2013, Windows 7, Windows 8, One note, VB Script, Excel and VBA.

Most commented posts

  1. Excel 2013 very slow — 5 comments
  2. Formulas Not working when dragging down — 2 comments
  3. #1:Connect to Internet Explorer(IE) via VBA — 1 comment
  4. OneNote Tips and Tricks#9: — 1 comment
  5. Real Life Fact!! — 1 comment

Author's posts

Jan 09

Samsung SmartTV-YouTube App-Blackscreen

Quick fix for the samsung smartTV -Youtube App / NetFlix App – Black screen problem. Please watch the below video . Hope it helps. Please leave your comments below.

Oct 05

Google Pixel Phones

The first phone made by Google – PIXEL.   This time, Google has manufactured his own hardware and released two phones namely PIXEL and PIXEL XL . The interesting thing is it comes with VR headset ( Virtual Reality). Differentiated primarily by the size and resolution of their screens — 5-inch 1080p display on the …

Continue reading

Sep 26

Google Allo-Competitor for Whatsapp?

Google launched a new one this week called Allo. Google actually unveiled Allo (a messaging app) and Duo (a video calling app) at Google I/O in May, but just hours ago, Allo finally made its way to the App Store on iOS and Google Play on Android. “What’s the big deal?” you might ask. Google …

Continue reading

Aug 30

SharePoint CSOM- Turn off the formatted XML View

CSOM SharePoint View

Tools> Internet options> Content >Feed settings > Un check Feed reading view     Note: You have to close the browser and start it again

Mar 26

Excel 2013 very slow

Affected users: Global Problem:  Excel 2013 is very slow When I copy and paste some data Excel is crashing and taking long time Excel performance is really slow if I filter any data on the cell Solution:- Task 1: Increase your virtual memory Open the control panel > on the right hand top corner >Select …

Continue reading

Mar 23

“Cannot insert object” error in an ActiveX -Security Patch Issue

Affected Users: Global Problem:    You will get one of the Error in Excel   Object library invalid or contains references to object definitions that could not be found. Cannot insert object. Solution:-1   Please check your system whether you have Admin rights.  if not through following steps   Step1: Click the bottom of the right …

Continue reading

Dec 09

Sharon Fruit

I had the best fruit in my life. I still remember the taste of Sharon Fruit. It was delicious.. Yummy !!! Please check out my Facebook Sharon Fruit page if you are also interested !!    Click here to view my FB page. Feel free to hit the like button 

Mar 11

Formulas Not working when dragging down

Excel Issues/ Problem #1: Issue: Formulas Not working when I drag it down: when I drag a formula from the cell on downwards, the numbers remain the same in all the pasted cells. When I double click on the individual formulas, it updates. Solution: Go to Formulas Menu -> calculation- change it to Automatic   …

Continue reading

Mar 05

OneNote Tips and Tricks#9:

OneNote Tips and Tricks#9:  Take notes easily- using linked notes: OneNote allows you to take notes instantly while you are in live meeting or reading specific contents in the internet or using any of your office products. Solution:  1. Open OneNote > Review > Linked notes  > Start taking notes 2. The software icon will …

Continue reading

Feb 26

#2:Compare two lists instantly

Excel Intermediate:  #2:Compare two lists instantly Solution:  1. Select  range in both lists  2. Go to Conditional Formatting > Highlight Cells Rules > Duplicate Values > OK  Play this trick immediately to do your quick comparison instantly  Benefits: No need to spend time in writing formulas /code Instant way Alternatively you can watch my below video …

Continue reading