+ Reply to Thread
Results 1 to 2 of 2

Run-Time Error - Only when file "Opened" from server, works if file saved on local machine

  1. #1
    Registered User
    Join Date
    Los Angeles, CA
    MS-Off Ver

    Run-Time Error - Only when file "Opened" from server, works if file saved on local machine

    This is very strange and does not effect all machines. I have a file stored on a SharePoint site. If I send a link to the file in an email, some computers are getting:

    Run-Time error '-2147417848 (80010108)':Method'_Default' of object 'SlicerCaches' failed

    whenever they click an object that runs a macro reseting the Pivot Table Slicer filters.

    Other machines run the code with no problem. Making it even stranger is that the machines with the error work fine if the file is saved to their local machine or sent to them as an attachement in an email. The error can only be recreated when the file is OPENed versus SAVEed after clicking the link.

    The macro resetting the filters is shown below.

    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor
    Join Date
    Melbourne, Australia
    MS-Off Ver
    Office 2016

    Re: Run-Time Error - Only when file "Opened" from server, works if file saved on local mac

    This sounds like a security issue. Is the problem actually affecting machines or users? In other words, if a user of a problem machine logged onto one of the working machines can they access the file successfully? If not, it might be worthwhile comparing user access rights.
    Trish in Oz
    A problem well defined is a puzzle half solved

    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:

+ 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. if data file is opened as read only, then the macro gives an "error" message
    By leeluquem in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-13-2014, 11:13 PM
  2. Replies: 5
    Last Post: 10-08-2013, 04:33 PM
  3. MSoffice Outlook 2003 message to be saved in C dir with the file name "From" "Sent" "Sub"
    By shailendra0509 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-09-2012, 01:32 AM
  4. Replies: 4
    Last Post: 12-30-2011, 11:24 AM
  5. Excel file save error ("changes could not be saved")
    By donkrafft in forum Excel General
    Replies: 0
    Last Post: 01-27-2010, 02:31 PM


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