I want to create a dynamic SharePoint “thing” that updates when my Excel workbook updates
Hi,
Do I want a Site, a Page, an App, a Something Else? I don’t know.
What I do know is this: I want a central place where the employees can visit to figure out who is authorized to access parts of the company. This will change (dynamic), and I want to display this information based on the source data from an Excel workbook. As the workbook changes, the “thing” in SharePoint changes.
This has nothing to do with SharePoint access, so if that’s how you came away with this, get that out of your head. This has to do with employee access to different departments of the company. For example, John Smith has access to Departments A, B, and C, while employee Jane Johnson has access to Departments B and D. So, maybe I want to display that by employee name, or maybe I want to display that by department with authorized employees underneath.
However I want to display it, it needs to be dynamic and a touch-one situation: Update the Excel workbook, and the SharePoint “thing” changes – no need to update multiple locations. How do I make it dynamic, and am I looking to create a Site, or a Page, or what?
Feel free to paste links and examples and all that you can. I’m not against reading up on this – I just dont know where to begin.
Thanks.
Hi, Do I want a Site, a Page, an App, a Something Else? I don’t know. What I do know is this: I want a central place where the employees can visit to figure out who is authorized to access parts of the company. This will change (dynamic), and I want to display this information based on the source data from an Excel workbook. As the workbook changes, the “thing” in SharePoint changes. This has nothing to do with SharePoint access, so if that’s how you came away with this, get that out of your head. This has to do with employee access to different departments of the company. For example, John Smith has access to Departments A, B, and C, while employee Jane Johnson has access to Departments B and D. So, maybe I want to display that by employee name, or maybe I want to display that by department with authorized employees underneath. However I want to display it, it needs to be dynamic and a touch-one situation: Update the Excel workbook, and the SharePoint “thing” changes – no need to update multiple locations. How do I make it dynamic, and am I looking to create a Site, or a Page, or what? Feel free to paste links and examples and all that you can. I’m not against reading up on this – I just dont know where to begin. Thanks. Read More