Forum Discussion

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

Iron Contributor

May 29, 2017

Hi Alberto,

could you please try entering Ctrl+; to insert current date? Ctrl+Shift+; should be inserting current time.

Do you have any add-ons running?

Please also see the following thread for some recommendations

https://social.technet.microsoft.com/Forums/lync/en-US/dccd77b7-8faa-4dbb-95be-28f438123301/insert-current-date-ctrl-not-working-probably-in-excel-2013?forum=officeitpro

Yury

Alberto Paolini

Copper Contributor

May 29, 2017

there are no addons running. I even tried to go to the website you linked me but with no success. when I press CTRL+; appears the loading symbol instead of the pointer, but for half a second and then it happens nothing.

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
  Copper Contributor
  May 29, 2017
  it happens in every spreadsheet.
  - 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?