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

naridox

New member
Joined
Feb 23, 2017
Messages
30
Reaction score
0
Points
0
Location
NCR
Excel Version(s)
2013
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?
 
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?
 
Back
Top