Link two workbooks on a sharepoint

%3CLINGO-SUB%20id%3D%22lingo-sub-1199012%22%20slang%3D%22en-US%22%3ELink%20two%20workbooks%20on%20a%20sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1199012%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20of%20automatically%20updating%20a%20query%20connection%20in%20a%20workbook%20saved%20in%20a%20sharepoint%20folder.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20created%20a%20connection%20from%20our%20Access%20Database.%20To%20update%2Fsync%20it%2C%20I%20would%20open%20the%20workbook%20in%20a%20browser%20%2F%20Open%20in%20Desktop%20App%20%2F%20Under%20Data%20tab%20I%20click%20to%20refresh.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20just%20open%20the%20workbook%20in%20a%20browser%20and%20go%20to%20Data%20%2F%20Refresh%20Selected%20Connection%2C%20I%20get%20the%20following%20error%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%22The%20current%20selection%20is%20not%20within%20a%20refreshable%20region%20of%20the%20workbook.%20Select%20a%20refreshable%20region%2C%20such%20as%20a%20PivotTable%2C%20before%20clicking%20on%20the%20Refresh%20Selected%20Connection%20button.%22%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EIdeally%2C%20I'd%20like%20for%20it%20to%20refresh%20automatically%20when%20opening%20without%20any%20extra%20steps.%20When%20I%20set%20this%20option%2C%20I%20get%20the%20same%20error.%20I'd%20rather%20users%20didn't%20need%20to%20open%20the%20workbook%20in%20a%20desktop%20app.%20The%20data%20is%20very%20basic%20without%20any%20features%20that%20would%20necessitate%20opening%20it%20in%20a%20Desktop%20app...%20well%20apart%20from%20the%20connection%20refresh.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EPlease%20advise.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThank%20you%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EMarcin%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1199012%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20autorefresh%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

Hi 

Is there a way of automatically updating a query connection in a workbook saved in a sharepoint folder.

 

I've created a connection from our Access Database. To update/sync it, I would open the workbook in a browser / Open in Desktop App / Under Data tab I click to refresh.

 

When I just open the workbook in a browser and go to Data / Refresh Selected Connection, I get the following error

 

"The current selection is not within a refreshable region of the workbook. Select a refreshable region, such as a PivotTable, before clicking on the Refresh Selected Connection button."

 

Ideally, I'd like for it to refresh automatically when opening without any extra steps. When I set this option, I get the same error. I'd rather users didn't need to open the workbook in a desktop app. The data is very basic without any features that would necessitate opening it in a Desktop app... well apart from the connection refresh.

 

Please advise.

 

Thank you

Marcin