+ Reply to Thread
Results 1 to 4 of 4

Prevent Excel from starting from Sharepoint?

  1. #1
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,844

    Prevent Excel from starting from Sharepoint?

    I have made an Excel application that will create pdf's from a list of data. The Excel application and the pdf's live in a folder on Sharepoint.

    For most people in my office this works fine, the pdf is created and saved in seconds. For me, however, it takes up to 4 minutes(!) for the same process.

    I finally found that it depends on how you start Excel. If I start Excel by clicking the icon direct in the Office 16 folder then it works fast for me too.
    If I start Excel by clicking the icon in the Sharepoint folder then I get the slooooow behavior.

    What is going on? How can I be sure that this doesn't happen to one of my users? Something about Excel shortcuts and/or switches or something like that.




    My thread on a vaguely related issue here for anyone who wants something to read: https://www.excelforum.com/excel-pro...en-saving.html
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Prevent Excel from starting from Sharepoint?

    Do bioth shortcuts point to the same Excel or are there different targets being run?
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,506

    Re: Prevent Excel from starting from Sharepoint?

    I suspect one is loading the application locally, and the other is loading it across the network. Complete guess though.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  4. #4
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,902

    Re: Prevent Excel from starting from Sharepoint?

    This can be due to permission setting on SharePoint side. Check if you have different document launching permission from everyone else.
    Can't remember where exactly you'd find it, but try SharePoint administration or Site management (It's been a while since I extensively worked with SharePoint...)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Opening SharePoint file with VBA - disable SharePoint "Contacting the server" message
    By kopite2002 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-22-2013, 01:56 AM
  2. Replies: 0
    Last Post: 10-08-2013, 10:54 AM
  3. Excel and Sharepoint
    By roger556 in forum Excel General
    Replies: 2
    Last Post: 10-30-2012, 12:04 PM
  4. Replies: 5
    Last Post: 09-27-2012, 07:30 PM
  5. SharePoint to excel
    By xenos14 in forum Excel General
    Replies: 1
    Last Post: 11-07-2011, 12:47 PM
  6. Doublecheck with second lookup starting starting after first match
    By zekethewolf in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-06-2011, 06:36 AM
  7. Sharepoint and Excel - RSS, XML?
    By karobonas in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-03-2010, 07:06 AM
  8. Prevent multiple instances of Excel from starting
    By Robert Mulroney in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-21-2006, 08:10 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1