Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

LinkBack Thread Tools Display Modes
Old 02-13-2019, 05:23 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Join Date: May 2017
Posts: 424
ArviLaanemets will become famous soon enough
Default Strange behavior of Excel file with ODBC query in MS Cloud SharePoint

Lately we upgraded to MS Office 2016/Office365. The license includes also SharePoint.

I myself haven't used Office in cloud jet. Today I was contacted by user, who uploaded an Excel report file into Sharepoint, and was surprised with its behavior.

The report file has an ODBC query to another Excel workbook, which is on shared resource in our LAN. When the report workbook in cloud is opened, this source workbook is opened too - by default as read-only, but whenever it is activated first time, it opts to make it to read-write.

Is it normal behavior?
Is there a way to skip the opening of source workbook? The idea at start was, that users get the data they need to see, and they can't edit it. It worked OK, until both workbooks were in LAN.
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Strange Behavior with a Graph in Word RP McIntosh Drawing and Graphics 1 01-27-2019 05:38 PM
strange search behavior cyraxote Word VBA 0 05-05-2017 03:00 PM
Strange macro behavior in 2016 Ulodesk Word VBA 5 04-02-2017 03:34 PM
Strange OLE Link Behavior after emailing or moving a File ptmuldoon Word 1 12-03-2014 02:28 PM
Pasting - strange behavior SatControl Word 5 02-14-2010 12:57 PM

All times are GMT -7. The time now is 07:23 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft