dragging cell in excel not working office for mac

Saved it as both a.xls and a.xlsx.

MS 2013. The drop down does not exist when I open it in oo 4.1.1 The list of data for the drop down is still there, but no drop down.

If I create a.xls drop down from inside of 4.1.1, it is visible and can be used by Excel.

If you modify and save the workbook again in excel, it breaks the drop down in 4.1.1 again Help or insight would be appreciated.

Including any cell you click on in the document is a reference to the drop down list.

It does work when you save it as a.xls, edit it in excel and then reopen it in oo.

I am unclear from your example what you are doing which makes the drop down list persistant.

When the target of the drop down box is on a different sheet and saved in.xlsx format, oo doesnt deal with it correctly and it is lost.

If you then save back to.xls you have effectivly removed the drop down box.

The validation range needs to be on the same sheet which should be no problem having a billion cells per sheet or 700,000 in xls (last cell in xls is IV65536).

The ODF standard (.ods,.odt.odp etc.) allows you to keep the range anywhere in the same document.

Dragging Cell In Excel Not Working Office For Mac