7

SharePoint 2010 / SQL Server 2008 R2

One of my users reported a problem opening files yesterday. Upon opening a file she would receive this string of error messages: No Connectivity 1
Clicking "Retry Open" leads to: enter image description here
Then clicking "OK" brings up: enter image description here
Clicking "OK" there just leaves you with Excel (or whatever the appropriate program) at a dark grey background without a document loaded.

I've split up my site collection by departments and each departments' document libraries are on their own content databases. This problem is only occurring in the Operations CDB. I can replicate the errors on my machine.

Here's where things get more interesting- If I open Windows Explorer and navigate to the parent folder of that .xlsx file and then rename the file (or create a copy with a unique name) then that renamed (or copied) file will open just fine. You can then rename either of those files to the original file name and it will once again fail to open.

What's going on here?

1
  • Were you able to find a solution for this
    – user31445
    Jul 10, 2014 at 20:08

1 Answer 1

0

This is going to sound really crazy but this worked for me. Have the last person who edited the file do a check out via the UI, then immediately undo the checkout. Now open your copy of Excel and make sure that you do not have the 'Save Thumbnails' option selected. You should now be able to open the file.

2
  • Sorry, no dice. :\
    – newuser
    Nov 13, 2012 at 17:00
  • Worth a shot. If you can reproduce this easily enough, it might be time to get Microsoft involved as they can provide the proper SQL queries that can highlight where this might be happening. If you do bring them in, can you please post the details here? I know you are not the only person who has this issue, though you do seem to be the only one that can regularly reproduce it, which is essential when dealing with Microsoft Support.
    – Dave Wise
    Nov 13, 2012 at 17:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.