+ 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
    10-16-2014
    Location
    Los Angeles, CA
    MS-Off Ver
    2010
    Posts
    1

    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
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075

    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:
    http://www.excelforum.com/faq.php?fa...b3_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

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