locked
Error opening file; seemingly unrelated sharepoint path RRS feed

  • Question

  • Sorry for no screenshot, posting this from work where I could add a screenshot directly, but can't access free image hosting sites as required by the forum (URL instead of direct attachment)

    I created a workbook months ago, and handed it off to end users (I haven't touched it recently). Everything worked fine until this week. Now, when users (including myself, once I started investigating) are getting this warning error when opening the file, both from the LAN or also from local copies made from the LAN copy:

    "Unable to open https://share.company.com/users/userID/AppData/Local/Temp/Temp1_SomeFileName.zip/SomeFileName.xlsm. The internet site reports that the item you requested could not be found"

    [italics are where I replaced the real info with generic, to provide a cleaner example] The SomeFileName is not the same name as the file being opened, which just adds to the weird. I tried accessing the Sharepoint URL directly via my browser, but was unsuccessful (it is my userID that shows up in the error message, regardless of which user tries to open it). Because it is just a warning error, the users can then continue on to the file, but asking users just to ignore the error is not an acceptable solution.

    The one thing that changed over the weekend is we had a power outage and our servers were restarted. Maybe that resulted in the loss of temp files, but this file was on the LAN not hosted via Sharepoint so I'm not sure why a temp file would even have been saved out there on what appears to be a sharepoint path.

    Most importantly, I'm not sure where this link would be stored in the workbook, so I can remove or reset it. I checked properties, and also all formulas.

    Has anyone run into this before? The closest I found was http://support.microsoft.com/kb/2387587/en-gb but that still doesn't explain why the link would point to a sharepoint location, or how to fix the problem.

    Using Excel 2010 x32, local installs on our PCs, and a shared LAN folder. Most folks have Win7 x32, a few have Win7 x64

     Thanks!!

    Wednesday, October 29, 2014 8:30 PM

Answers

  • Hi,

    Have you also checked in Name Manager under Formulas tab -> Defined Names -> Name Manager? Do you find a named range which refers to that link?

    Regards,

    Melon Chen

    Forum Support


    Come back and mark the replies as answers if they help and unmark them if they provide no help.

    If you have any feedback on our support, please click here
    • Marked as answer by Keith Ruck Thursday, October 30, 2014 3:07 PM
    Thursday, October 30, 2014 7:06 AM

All replies

  • Hi,

    Have you also checked in Name Manager under Formulas tab -> Defined Names -> Name Manager? Do you find a named range which refers to that link?

    Regards,

    Melon Chen

    Forum Support


    Come back and mark the replies as answers if they help and unmark them if they provide no help.

    If you have any feedback on our support, please click here
    • Marked as answer by Keith Ruck Thursday, October 30, 2014 3:07 PM
    Thursday, October 30, 2014 7:06 AM
  • Wow, there were two extra named ranges in there that I hadn't recalled creating or seeing before, but that did the trick- thank you!
    Thursday, October 30, 2014 3:08 PM