I think I'm in the right place here. I have desktop Excel and created a Master Data file and individual workbooks for each of our reps. These individual workbooks each have a PowerQuery to pull the data for that individual from the Master Data file to their own. The system works perfectly for me.
When I go to the SharePoint folder online and open up one of the rep workbooks, I get a popup "Query and Refresh Data - Be careful. This workbook contains one or more queries that might be unsafe. Do you want to enable these queries?" When I push "Yes" it loads properly.
However, when one of the reps tries to open their workbook on SharePoint, the popup does not appear and the tabs with the PowerQueries are blank while it just says "Calculating" indefinitely in the lower-right corner.
I should note that the company subscription we have for Office 365 only grants the reps online access - they do not have Desktop. Is that causing the issue, is there a permissions setting I need to enable, or is there something else preventing them from loading these sheets?
Bookmarks