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.