Forum Discussion

Jambo97's avatar
Jambo97
Copper Contributor
Nov 03, 2024

Office 365 Won't let me have a none absolute cell reference in the Data Validation

Been beating my head against a wall for a few days trying to figure out how to get a dependent drop-down list to function in the Desktop Office 365 version of Excel.   I've finally found something ...
office 365
Lorenzo's avatar
Lorenzo
Silver Contributor
Nov 04, 2024

Jambo97 

I can't remove either of the $ signs without it refusing to accept it. Is there a work around to this

I'm on 365 desktop  where I removed the $ before the row# no problem - in attached file (downloaded from your other thread)

Resources