Windows 10: Can't Format Excel 2016 Spreadsheet

Opening a spreadsheet i use a lot and found that i couldn't format my charts. All options are grayed out. Screenshot is below. This is happening to all my spreadsheets. I can enter data and it shows up in the charts, but i can't format or modify the chart. How can i restore functionality to Excel?Using Windows 11, Excel 2016Thanks!

:)

 

Problem Associating Spreadsheet Files with MS Excel 2010 After Launching an MS Excel 2016 Trial ...

I use MS Excel 2010, and after launching what was a pre-installed version of MS Excel 2016 one time, my spreadsheet files are now associated with the soon to exprire (it expires today) trial of MS Excel 2016. I am unable to restore the association with
MS Excel 2010 via the Control Panel's 'Default Programs' option.

How can I reset the file association so that my spreadsheet and csv files are associated with MS Excel 2010, and
not MS Excel 2016?

Under ... Set Your Default Programs >>> Excel 2016 >>> Choose Defaults for This Program >>> Set Associations for This Program ... the options to deselect cannot be changed. I believe the responsible animal is at the bottom of the file-type list, under
'Protocols'; its check box is marked, and it is identified as 'MS-EXCEL Url:Excel Protocol Microsoft Office 2010.'

I'd guess that declaration specifies that my spreadsheet and csv file associations are set to MS EXCEL 2016, and not MS EXCEL 2010. However, as with the other options, it cannot be unchecked.

I believe this requires a registry edit similar to this Fixing an Excel File Type Association After Upgrading ... but
one that is specific to my situation.

Please advise.

Many Thanks!

OS: Windows 10 64-bit Pro

 

Problem Associating Spreadsheet Files with MS Excel 2010 After Launching an MS Excel 2016 Trial ...

Why not uninstall the trial copy of Office 2016?

Press Windows key + R

Type: appwiz.cpl

Hit Enter

Scroll through the list, select Office 365, then click Change/Uninstall on the command bar.

Restart when complete then check then try opening the spreadsheet in Excel 2010.

 

Working with Excel spreadsheets in OneNote Windows 10

Windows 8 and OneNote 2016 have some good features when working with Excel Spreadsheets. e.g. In OneNote 2016 there is a Microsoft Excel button that allows new or existing Excel spreadsheets to be opened and edited. Once opened there is an edit button in
upper left corner of the spreadsheet. When clicked. Excel opens and one can add data and edit the spreadsheet. Then when you quit Excel the new changes to the spreadsheet appear in the OneNote version of the spreadsheet. Very neat!

I don't find any way to edit spreadsheets in OneNote for Windows 10. In fact I find no good way to work well with Excel and OneNote. I find I can open a Excel spread sheet in OneNote.

What am I doing wrong?

Please help

Dr. John Shaughnessy PhD