Microsoft Office Forums Strange behavior of Excel file with ODBC query in MS Cloud SharePoint

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-13-2019, 05:23 AM
ArviLaanemets ArviLaanemets is offline Strange behavior of Excel file with ODBC query in MS Cloud SharePoint Windows 8 Strange behavior of Excel file with ODBC query in MS Cloud SharePoint Office 2016
Expert
Strange behavior of Excel file with ODBC query in MS Cloud SharePoint
 
Join Date: May 2017
Posts: 463
ArviLaanemets will become famous soon enoughArviLaanemets 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
Reply

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 behavior of Excel file with ODBC query in MS Cloud SharePoint Strange macro behavior in 2016 Ulodesk Word VBA 5 04-02-2017 03:34 PM
Strange behavior of Excel file with ODBC query in MS Cloud SharePoint Strange OLE Link Behavior after emailing or moving a File ptmuldoon Word 1 12-03-2014 02:28 PM
Strange behavior of Excel file with ODBC query in MS Cloud SharePoint Pasting - strange behavior SatControl Word 5 02-14-2010 12:57 PM


All times are GMT -7. The time now is 03:58 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft