Category Archive: Excel Issues/Problem

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 »

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 »