Forum Discussion
Linking Data from One Workbook to Another and having Cells there stay organized with sorting
Hello, I am needing help with keeping cells I input in a workbook that is linked to another workbook staying organized when the original workbook has a filter change. I have a workbook that I inpu...
The issue with this setup is you need to use a dynamic array function like SORT which requires the external workbook be open to calculate. Another approach might be to work together with others in the same file and use Sheet View.
https://support.microsoft.com/en-us/office/create-and-manage-sheet-views-in-excel-0eea3dc5-d7d1-44c5-a953-25ebfbd6c1a6
https://support.microsoft.com/en-us/office/create-and-manage-sheet-views-in-excel-0eea3dc5-d7d1-44c5-a953-25ebfbd6c1a6
- I do not believe sheet view will be an option for me as it is not saved on one drive. It is saved within a public shared drive on a local network.
