Results 1 to 2 of 2

Thread: Excel View on SharePoint for Pivot Chart Changes Connection on Every Refresh

  1. #1
    Acolyte naridox's Avatar
    Join Date
    Feb 2017
    Location
    NCR
    Posts
    30
    Articles
    0
    Excel Version
    2013

    Excel View on SharePoint for Pivot Chart Changes Connection on Every Refresh



    Register for a FREE account, and/
    or Log in to avoid these ads!

    GOAL: Create SharePoint-mounted Excel dashboard of live SharePoint List data without third-party apps or custom coding.

    ATTEMPT: Found blog on potential method through SharePoint IQY files and Excel Business View Web Part
    • Export SharePoint List to IQY file
    • Create Pivot Table and Chart connected directly back to the original SP List connection via "owssvr"
    • Load new excel doc to SP document library
    • Load excel onto SP page view via Web Part - Business Data, Excel Web Access


    LEADUP: Attempts to "Refresh Connection" produced error based on "The following connections failed to refresh:"

    ACTUAL PROBLEM: Refreshing produces incorrect data source name

    • Original data source: owssvr
    • Error on First Refresh: owssvr1
    • Error on Second Refresh: owssvr2


    Every attempt to refresh changes the original connection name which, obviously is the WRONG connection name.

    Why does this happen and how can I refresh only to the correct connection?
    Christian
    Information Designer
    National Capital Region

  2. #2
    Acolyte naridox's Avatar
    Join Date
    Feb 2017
    Location
    NCR
    Posts
    30
    Articles
    0
    Excel Version
    2013
    I'm prepared to close the thread due to lack of activity, but I can't find how. I've looked in the Resources and Knowledge Base but I can't find a Forum how-to guide. Can someone direct me how to close the thread?
    Christian
    Information Designer
    National Capital Region

Tags for this Thread

Posting Permissions

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