Maintaining Multiple Common Drop down lists across files

Hi IAMS_Work_in_Progress,

Welcome to the Numbers forum!

No. Numbers does not link between documents. And I am glad because moving documents around the file system breaks those links.

Also, I recall many times when a colleague would send me an Excel document that depended upon other documents, but did not send those other documents to me. And the colleague could not understand why I did not see what they could see. Doh!

Please reply with your overall aim (linking drop down lists*) and perhaps we can find a solution.

*In Numbers, drop down lists are called Pop-up Menus.

Regards,

Ian.

I understand your question from the point of view of Excel, where drop down lists can be populated by the content of a separate range of cells, whose values can change dynamically.

Alas, there's no such thing is Numbers and Numbers' pop-up menus are a totally different thing. Their options are set in the format of each cell themselves.

See How do I create a drop down list in numbe… - Apple Community for a good description.

Hi IAMS_Work_in_Progress,

Select the cells you want to edit. Click on + to add or - to delete. All selected pop-ups will accept the changes, but retain their settings.

All the pop-ups now contain guavas, but have not changed their settings.

Regards,

Ian.