microsoft excel
2 TopicsSetting Up SharePoint FIrst Time
Hi We moved files from a local drive to to SharePoint (creating a site) in the process. The problem we have incurred is on excel sheets that have VLOOKUPs that reference another workbook. If both workbooks are moved to sharepoint should it update the external references or do you have to do this manually for each spreadsheet? Thanks StuartSolved1KViews0likes1CommentSharepoint Excel doc not receiving data from Form
I created a Sharepoint page that has an Excel doc with a Form in the document which looks like a survey for over 50 people in our company to fill out requests. The Form is embedded in the Sharepoint home page. Using a modified "Notify the Team" Flow, once the request is submitted through the survey that triggers an email to the person who submitted so that they have a record, and that data then populates the Excel doc within the Sharepoint page. Everything has been going smoothly for the past 2 months, until last week when data that is submitted no longer populates the Excel doc. However, the flow history shows that the flow successfully ran. It's as if the data is getting "stuck" in limbo. When I submit a dummy request afterwards, that "pushes" the stuck data into populating the Sharepoint doc. Is there a way to fix this? Is a connection broken? Is this the appropriate place to ask? I appreciate any help. Thanks!1.2KViews0likes2Comments