+ Reply to Thread
Results 1 to 1 of 1

User without Desktop Excel using a file on Sharepoint with a PowerQuery

  1. #1
    Registered User
    Join Date
    03-07-2013
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2007/2010, Outlook 2007/2010
    Posts
    60

    User without Desktop Excel using a file on Sharepoint with a PowerQuery

    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?
    Attached Images Attached Images

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Outlook macro transfer file from sharepoint to desktop folder
    By aarona in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 11-25-2019, 02:34 AM
  2. [SOLVED] Using PowerQuery(2013) to Access and Update Sharepoint File
    By dsharman in forum Excel General
    Replies: 2
    Last Post: 05-31-2018, 01:39 PM
  3. VBA to select SharePoint Content Type when saving Excel file to SharePoint
    By Luffk73 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-24-2017, 05:22 PM
  4. [SOLVED] Forcing a file to save to any user's desktop
    By Herr Rommel in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 11-24-2016, 05:48 PM
  5. [SOLVED] Macro for saving a worksheet to desktop by any user of the file
    By Hardup in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-30-2014, 07:17 AM
  6. Replies: 0
    Last Post: 10-08-2013, 10:54 AM
  7. Macro that Selects Specific Excel Worksheets to a PDF file & Saves to the User's Desktop
    By Excel Wet Behind Ear in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-31-2013, 01:15 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1