•2 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to refresh a table that is tied to a sharepoint form without going to the table every time
Our take
If you're facing challenges refreshing tables linked to SharePoint forms, you're not alone. A recent update may have disrupted the automatic refresh feature you relied on, requiring manual updates for each table. This situation can be frustrating, especially when you're accustomed to a more efficient workflow. Fortunately, there are options to streamline this process. Exploring solutions like Power Automate could help automate data refreshes, although it may require some adjustments to ensure compatibility with your forms and tables.
Hello!
I have a couple of tables that are populated from forms that various team members fill out and I bring this into a sales report via Power Query. For quite a long time, when I would refresh the PQ query that would bring in the new data, the table would auto refresh but awhile ago there was a change that broke this automatic refresh (I think a MS update from awhile ago?) and now I have to go to each table that has a form, open the sharepoint link, let it update, and then refresh my query to bring in the data.
This is an improvement from a share file that had too many issues with users entering wrong data and has been the best solution for a while but the having to manually go to each table and refresh it daily is driving me crazy.
What are my options to get this to refresh automatically if its within a form? I tried to dip my toe into power automate but for some reason these forms/tables do not show up within it and I have not had success using that (but I could also be doing it wrong).
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- I need a way to combine multiple workbooks to use in a pivot table that can be refreshed through sharepoint.I have 5 spreadsheets in a folder on sharepoint and one on a separate folder in the same team site. These track contacts made by clients. Each workbook is for a LGA (location) and have the same structure. they have a sheet for each month and a table for that month. I initially struggled to use the Sharepoint Folder to combine these so created queries in Power Query. for each workbook I created a query which combined the 12 tables and then created a query which appended them. I was able to put this in a workbook and a pivot table to summarise where we were up to. it worked really well. the permissions were set using organisational account. this lasted about a day and now I cannot refresh it. I can refresh in the power query editor but not in the spreadsheet. I have opened it in the desktop version and also the same problem. I am now getting errors about legacy connections. I then tried the Sharepoint folder which finally worked but seem I can combine the January tables for the five spreadsheets but then I would need to do the same for each month. I would love any suggestions for this to consistently work and refresh from our sharepoint site (excel online). submitted by /u/Eastern_Echidna5680 [link] [comments]
- Power Query refresh speed with multiple usersHello all. I have a report that has multiple queries with data sources saved in SharePoint. Enable Fast Data load is checked in all the queries. There are about 10 users, with reported run time of around 5-10 minutes. But for me and one user, it takes 30-60 minutes to finish refreshing. I have already made some improvements in the initial code, and did a clean up of old raw data files in SharePoint but this resulted to minimal improvements. Given that all users have the same laptop configurations and are connected to the same internet connection, what are some steps I can do to do improve the speed on the queries? submitted by /u/SYSTEMOFADAMN [link] [comments]
- Power query and manual table next to itHi, I want to pull data verbatim from a spreadsheet my team uses and use data from it for my own purposes. The main goal for using power query is that the data updates on my spreadsheet. Mainly, if any new entries are added at the bottom. I also have some manual fields that I need to add that correspond with the power query data. I've added another table beside the power query data, and filtering it causes the data on both sides to adjust correctly. I'm mainly concerned that, if the entries are rearranged or sorted on the original sheet, that my tables will not align after a refresh. Also, if a refresh would break my table alignments at any point. Is my fear founded? Is there a way to combine the two features that I need into a single table? submitted by /u/Perspective-Guilty [link] [comments]
- PowerQuery hangs forever in refresh when multiple computers are used to editI'm having a sudden problem in which when I make edits on another computer and try to refresh PowerQuery on my primary computer, it refreshes forever or sometimes refreshes for hours before throwing up a random memory error. Normally, the refreshes take between 3 and 10 minutes. I've used this setup for a year now with no issues before last week. I have an relatively elaborate PowerQuery setup that pulls in shared data from many sources, including online, Dropbox, SharePoint, OneDrive, and in-workbook excel tables. Lots of merges, lots of custom formulas. All file locations are variable parameters that are changed via a dropdown in Excel. I do most of my work on an up-to-date Windows 11 version of Excel running on a Mac via Parallels. The other machine I occasionally edit on is another up-to-date version of Excel on Windows 11. They are synced via Dropbox. At first I thought my VM was corrupted, so I reinstalled fresh. It worked fine until the next time I edited on another machine. I've deleted all PowerQuery and Excel caches and it still happens. Nothing I'm doing is new, so I'm not sure why it suddenly breaks. Any thoughts? submitted by /u/WorldsGreatestWorst [link] [comments]
Tagged with
#Excel alternatives for data analysis#generative AI for data analysis#real-time data collaboration#natural language processing for spreadsheets#big data management in spreadsheets#conversational data analysis#intelligent data visualization#data visualization tools#enterprise data management#big data performance#data analysis tools#data cleaning solutions#rows.com#real-time collaboration#Excel compatibility#financial modeling with spreadsheets#Excel alternatives#SharePoint#Power Query#automatic refresh