Hi, I am new to this forum! I am trying to understand whether the following scenario is possible..
I use SharePoint at work to allow multiple users to view spreadsheets. Is it possible to have a workbook uploaded to SharePoint pull information from other workbooks uploaded to SharePoint? My goal is to manage one executive workbook and have multiple users upload information into other separate workbooks which would feed into mine.
I realize this is both an Excel AND a SharePoint question. Thank you in advance!
I use SharePoint at work to allow multiple users to view spreadsheets. Is it possible to have a workbook uploaded to SharePoint pull information from other workbooks uploaded to SharePoint? My goal is to manage one executive workbook and have multiple users upload information into other separate workbooks which would feed into mine.
I realize this is both an Excel AND a SharePoint question. Thank you in advance!