Excel cursor changed to solid white cross instead of arrow, now dropdown menu not working

[ExcelHelp14]

Hi All,

I noticed that upon opening an excel file on my desktop, the excel cursor that's always an arrow has changed to a solid white cross (think of a + with a solid white filling) and now I'm unable to click on any dropdowns on my sheet. I am able to type in formulae but without the dropdowns working, my sheet has lost all functionality. Please advise! I would much appreciate any help I can get on the same. I perused other posts but couldn't find a solution, tried closing the sheets and re-opening, pressed F8 but to no avail.

Best regards,

 

[martindwilson]

try excel options/advanced check "enable fill handle+cell drag and drop"

 

[ExcelHelp14]

Hello,

I tried your suggestion, and "enable fill handle+cell drag and drop" is already checked. Didn't help... Any other advice?
Thank you for your time.

 

[martindwilson]

nope no idea,is the workbook shared or something?

 

[ExcelHelp14]

Hello,
No the workbook isn't shared... The problem still persists and I'm unable to use the dropdowns...