Forum Discussion

Franf44's avatar
Franf44
Copper Contributor
Feb 16, 2019
Solved

Excel scenario multiple cell selection issue

Hi, I try to use scenario to change 3 cells content. I type a name then I select the 3 cells by using ctrl+click (as usual): I get $G$27 $H$27 $B$11 then I click OK. At that time only one cell is ...
excel
  • Franf44's avatar
    Franf44
    Feb 22, 2019

    Hi,

    I eventually solved the issue. Indeed I had same issue with some excel functions that request more than one parameters.

    The problem was located in windows parameters where list separators was set to ';' and ','.

    I removed the ',' and everything is now back to normal.

    Multiple cell selection create list with ; separator now  e.g. $G$27:$H$27;$B$11 instead of $G$27:$H$27 $B$11

Franf44's avatar
Franf44
Copper Contributor
Feb 19, 2019

Hi,

Nobody else has same issue I have ?

Regards
Francois

Franf44's avatar
Franf44
Copper Contributor
Feb 22, 2019

Hi,

I eventually solved the issue. Indeed I had same issue with some excel functions that request more than one parameters.

The problem was located in windows parameters where list separators was set to ';' and ','.

I removed the ',' and everything is now back to normal.

Multiple cell selection create list with ; separator now  e.g. $G$27:$H$27;$B$11 instead of $G$27:$H$27 $B$11

Resources