Forum Discussion

Alberto Paolini's avatar
Alberto Paolini
Copper Contributor
May 28, 2017

a function not working (current date function)

Hi, when I try to add to my document of excel the current date (in a permanent way, so that it doesn't change every time I open Excel) I use the function: CTRL+SHIFT+;      The fact is that when I ...
excel
Formulas and Functions
Macros and VBA
office 365
Yury Tokarev's avatar
Yury Tokarev
Iron Contributor
May 29, 2017

Hi Alberto,

 

Does this happen just in one file, or in every spreadsheet you open (even a blank one)?

 

If it is just one file, does it have macros within it? 

 

Thanks

 

Yury 

 

 

Alberto Paolini's avatar
Alberto Paolini
Copper Contributor
May 29, 2017
it happens in every spreadsheet.
  • Yury Tokarev's avatar
    Yury Tokarev
    Iron Contributor
    May 29, 2017

    If you have not done so, could you please load Excel in safe mode (hold Ctrl button, double click Excel icon, then accept the prompt) and try the shortcut to see if it works?

    • Alberto Paolini's avatar
      Alberto Paolini
      Copper Contributor
      May 29, 2017
      no success even this time. the icon becomes a light blue circle for half a second but it happens nothing at the end.
      • Yury Tokarev's avatar
        Yury Tokarev
        Iron Contributor
        May 30, 2017

        Hi Alberto,

         

        could you please try the following:

         

        1. Close Excel 

         

        2. Go to the Excel start folder with the Personal Workbook. Normally, you can find it as below - please  use your user name instead of the text 'ReplaceWithYourUserName'

         

        C:\Users\ReplaceWithYourUserName\AppData\Roaming\Microsoft\Excel\XLSTART

         

        3. If you see PERSONAL.XLSB, please make a backup copy of it into a different folder - just in case you  wish to restore it in the future (in case it has some useful code)

         

        4. Delete PERSONAL.XLSB from the XLSTART folder

         

        5. Open Excel, then try the key shortcut

         

        Please let me know if it has worked

         

        Yury

Resources