客户有Excel 2019，我有Excel 365。溢出阵列的下拉阵列不适合客户工作
我创建的电子表格具有多个依赖性下拉列表，可以参考溢出数组。具体而言，下拉列表参考每个使用filter（）和sort（）的单元格。
客户有Excel 2019，并报告下拉列表不起作用。我确保在验证中选择了单元内下拉列表。我确保了该工作簿中的“ Advance＆gt; Advoction＆gt; Advance'Advance选项“对于对象，请显示：“全部选择。
我知道我可以创建一个ComboBox来复制下拉菜单的功能，但是我假设电子表格中使用filter（）和sort（）的所有其他单元格无法使用。
这是正确的假设吗？有没有办法在Excel 2019中使用这些功能？如果将文件上传到SharePoint，是否允许客户端使用该文件？
感谢您的考虑。这是我的第一篇文章。我希望这很清楚。如果没有，我将尝试进一步澄清。
再次感谢。
The spreadsheet I've created has multiple dependent dropdowns that reference spilled arrays. Specifically, the dropdowns reference a cells that each use Filter() and Sort().
The client has Excel 2019 and reports that the dropdowns don't function. I've made sure that In-cell Dropdown is selected in Validation. I've ensured File>Options>Advanced>Display Options for this workbook has "For objects, show:" All is selected.
I'm aware that I could create a combobox to replicate the function of the dropdown, but I'm under the assumption that all other cells in the spreadsheet that use Filter() and Sort() wouldn't work.
Is that a correct assumption to make? Is there a way to have these functions work in Excel 2019? If the file were uploaded to SharePoint, would that allow the client to use the file?
Thanks for your consideration. This is my first post. I hope it was clear. If not, I will try to further clarify.
Thanks again.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
客户端将文件上传到SharePoint，并能够在没有问题的情况下使用该文件。这解决了因子下拉次数不正常的问题，还确保文件的其余部分与过滤器（）和sort（）函数正确奏效。
The client uploaded the file to SharePoint and was able to use the file without issue. This solved the issue of the dependent dropdowns not functioning, and also made sure the rest of the file worked correctly with the Filter() and Sort() functions creating spilled arrays.