4

I got an issue from one of my users, where he would get the following message whenever he opened a particular excel file stored in a document library.

The workbook is currently open by 256 users. A maximum of 256 users can have a shared workbook open at the same time. The workbook will be opened read-only. You can try again when one or more users have closed the workbook.

I would receive the same error when opening the workbook myself. According to the user, this is a relatively obscure book that shouldn't be being used by that many people. The only interesting thing I noticed about the workbook is that it had over 370 versions associated with it.

Unfortunately, the user "resolved" the issue by deleting the workbook and adding it back again. However, if I could present a possible answer why this occurred, it would be appreciated.

Anyone have any thoughts? Or, if it's actually a 256 user limit, anyone know how I can figure out who currently has the workbook open?

bumped to the homepage by Community 2 days ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

  • Glitch in the matrix, connections not dropping properly. – Aboba Jun 26 '14 at 21:24
0

Shared workbooks have been a source of trouble for years and should be avoided. Why do you use an Excel file if you have SharePoint? Instead of the file, create a SharePoint list and multiple users can simultaneously edit the list.

  • Although I agree with you Tevylyn, there may be other factors in play, that are unavailable through SharePoint Lists. There are many features baked into Excel, you can't use otherwise; Pivots, Complex Formulas, Charting, etc. – Quinn Johns Apr 11 '15 at 1:24
  • @QuinnJohns, SharePoint can be used for data entry. Then create a data connection to the list in Excel and do reporting with Pivots, calculations, charts, etc. – teylyn Apr 11 '15 at 21:43
  • I can agree with that, but just saying there is a degree of flexibility by doing shared workbooks. Team members may be using the same items, and having to do the added work to creating the data connections, is costly, for non-skilled users of SharePoint. At any rate, was just making commentary. I realized after the fact, how old this thread was. Thanks for responding. :) – Quinn Johns Apr 12 '15 at 0:28
  • This does not attempt to answer the question. – Nullldata Jan 9 at 12:00
  • @Nullldata, if you look at the Q you can see "Anyone have any thoughts?" That's what my answer is about. I'm presenting an alternative approach that avoids the problem the user is having altogether. It does answer the question as posed at the time. Meanwhile, there are other options. – teylyn Jan 9 at 19:58
0

While I cannot explain why this issue occurs, however just like you - the fix for me was:

  1. Save the file to your desktop.
  2. Overwrite the affected file in SharePoint with the locally saved copy.

This made the issue disappear for me.

0

Another cause for this :

enter image description here

is this:

enter image description here

Unsharing the workbook fixed the issue for me.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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