Mark Minasi's Tech Forum
Sign up Calendar Latest Topics
 
 
 


Reply
  Author   Comment  
Jon_AK

Avatar / Picture

New Friend (or an Old Friend who Built a New Account)
Registered:
Posts: 74
Reply with quote  #1 
Am in the process of moving our shared excel workbooks to Sharepoint / Onedrive.  In our network, I currently have a GPO that creates a desktop icon with a link for the clients in our network to open the shared folder which contains our excel workbooks.  Excel workbooks are all in shared mode as well which is another story.  I want to make the access to the Ondrive folder to match what the process is now....double click the desktop icon and it opens up the folder location.

What I have discovered about doing this in Onedrive is having to browse online to the folder and manually clicking on the sync button.  That in turn creates a link within the Windows file explorer after which a shortcut on your desktop can be made.  Is there anyway with Group Policy to do this automatically?  I'm trying to avoid going from client to client to establish the link.
0
lady_mcse

Avatar / Picture

Senior Member
Registered:
Posts: 103
Reply with quote  #2 

Excel Workbooks & Shared mode - Ugg, I'm curious to know what you end up finding with that. Historically with the older versions of SharePoint, the shared workbooks would not work, and could even get corrupted or infinitely stuck in a "someone else is editing this workbook" mode. So if you have feedback to share on that, I'm interested in hearing.

As for the shortcut on desktop, I think I'd have to go back to the question of "why." You probably did this once upon a time because people couldn't find their stuff. Welcome to O365 where that's going to get even harder and everyone's supposed to just rely on Search and predictive suggestions from O365 to get you to your files. That was my snarky commentary.

Now for the less snarky version, why doesn't the new O365 way work for you? There will be a bit of a learning curve for your workers, but assuming they learn the new way of doing things, shouldn't it work as well or better than a desktop shortcut? In Excel 2016, you can have it display up to 50 recent workbooks (I have mine set to 25). When I hit File > Open, I'm shown a pretty big obvious "OneDrive" link, so if most of my stuff is in there, then I shouldn't be needing other desktop shortcuts or links.

With the new Windows 10 sync and OneDrive, I've found that syncing folders works pretty well except for the fact that the File > Open > OneDrive will only show you the synced folders at first, you do have to hit browse to go out and get anything you haven't synced. But it's way better than having to sync gigabytes of data all the time.

0
Jon_AK

Avatar / Picture

New Friend (or an Old Friend who Built a New Account)
Registered:
Posts: 74
Reply with quote  #3 
Quote:
Excel Workbooks & Shared mode - Ugg, I'm curious to know what you end up finding with that. Historically with the older versions of SharePoint, the shared workbooks would not work, and could even get corrupted or infinitely stuck in a "someone else is editing this workbook" mode. So if you have feedback to share on that, I'm interested in hearing.

As for placing the desktop link onto each client desktop, that has always worked.  The URL for the shared folder which contains all the workbooks works the same way as if it were on the premise server.  The only issue with that is it loads the folder in "online mode".  It requires that the file you wish to open be selected and then open it with Excel instead of Excel Online.  The VBA code I have in the workbook is not supported by Excel Online... at least that is the error I get displayed.

Quote:
As for the shortcut on desktop, I think I'd have to go back to the question of "why." You probably did this once upon a time because people couldn't find their stuff. Welcome to O365 where that's going to get even harder and everyone's supposed to just rely on Search and predictive suggestions from O365 to get you to your files. That was my snarky commentary.

That is the whole issue.  I have found the clients will not typically go out of their way to make a couple other selections to open the workbook.  If it doesn't happen with the first double click, I get a phone call.

Quote:
Now for the less snarky version, why doesn't the new O365 way work for you? There will be a bit of a learning curve for your workers, but assuming they learn the new way of doing things, shouldn't it work as well or better than a desktop shortcut?

Frankly, I like the new way, and since it is really nothing more than loading the share for the first time, telling Onedrive to sync there, and then looking in file explorer for the link, it comes down to a matter of patience...on my end that is...dealing with the questions...change doesn't come easy where I am.  I like the fact that any changes once saved show up in less than 30 seconds and the VBA code is directly supported.

As for being snarky...  [crazy] nah, I don't mind...  I've heard a lot worse....
0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:

Easily create a Forum Website with Website Toolbox.