Wednesday, 15 July 2015

Missing Native Excel functions

At times because of some macros some native excel functions would get disabled, if you would want to reset that, you need to do the following steps

 

Locate the users setting of excel, generally here is the path for my system

C:\Users\venu\AppData\Roaming\Microsoft\Excel

 

Delete all the contents of the folder

 

When excel is opened it will restore the settings.

 

IN my system Insert function button (ALT + I + R) was not working, and now its taken care.

 

 

No comments:

Post a Comment