Hello. Our team is working with Office 365. We have a central workbook that gets created each day that has ~2000 records, and then everyone else has a personal workbook that pulls in that data, and they filter on their name to process their records. In the process, they enter notes into a 'user notes' column. During the update of their personal workbooks, their user notes are maintained and transferred to the newly updated data. The desire is to be able to have EVERYONE'S user notes maintained and pulled into the central workbook. This way, there can be much more efficient workload sharing. Please note, I've tried a shared workbook, which is fine for a .xlsx file, but the individual workbooks are .xlsb, which in my experience (as well as with .xlsm), has not worked well at all with shared workbooks.
Does anyone have a thought about how I might create a process to enable individual user workbooks see everyone else's user notes? Thank you!
