Calgarypuck Forums - The Unofficial Calgary Flames Fan Community - View Single Post

ken0042 · 09-17-2019, 03:04 PM

I have a question that I hope somebody might be able to help with. We are looking to make cells in Excel fillable with a date picker; similar to what you can do in Google Sheets.

First you set the cell properties

Then when you double click on the cell you get a date picker:

We are using O365 installed on the desktop. We see a 3rd party app that claims to do this, but installing it comes with security issues of the 3rd party getting some level of access to the sheet.

Also tried saving the Google sheet as .xlsx and it didn't work.

Any suggestions would be appreciated!

09-17-2019, 03:04 PM	#69
ken0042 Playboy Mansion Poolboy Join Date: Apr 2004 Location: Close enough to make a beer run during a TV timeout Exp:	I have a question that I hope somebody might be able to help with. We are looking to make cells in Excel fillable with a date picker; similar to what you can do in Google Sheets. First you set the cell properties Then when you double click on the cell you get a date picker: We are using O365 installed on the desktop. We see a 3rd party app that claims to do this, but installing it comes with security issues of the 3rd party getting some level of access to the sheet. Also tried saving the Google sheet as .xlsx and it didn't work. Any suggestions would be appreciated!