# Any SharePoint users out there?

**URL:** <https://boards.straightdope.com/t/any-sharepoint-users-out-there/593145>\
**Category:** Factual Questions\
**Created:** [August 18, 2011, 12:30pm UTC](https://boards.straightdope.com/t/any-sharepoint-users-out-there/593145 "2011-08-18T12:30:11Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sandra\_nz](https://avatars.discourse-cdn.com/v4/letter/s/eada6e/32.png) [@sandra\_nz](https://boards.straightdope.com/u/sandra_nz)\
**Post date:** [August 18, 2011, 12:30pm UTC](https://boards.straightdope.com/t/any-sharepoint-users-out-there/593145/1 "2011-08-18T12:30:11Z")

</div>

Our company is moving from eRooms to SharePoint 2010, and I have a question.

One of the things that has always bugged me about eRooms is that if you have two seperate excel files, you can’t reference one in a formula in the other.

Does anyone know if this is still the case with SharePoint? I thought with it being a Microsoft product, it might solve this problem.

---

<div class="post-metadata">

**Author:** ![yoyodyne](https://avatars.discourse-cdn.com/v4/letter/y/a9a28c/32.png) [@yoyodyne](https://boards.straightdope.com/u/yoyodyne)\
**Post date:** [August 18, 2011, 1:30pm UTC](https://boards.straightdope.com/t/any-sharepoint-users-out-there/593145/2 "2011-08-18T13:30:17Z")

</div>

You can when you’re using the desktop version of Excel. The SharePoint Excel Services web app can’t. You’ll want to turn off versioning and checkout on the library that contains the workbooks.

---

<div class="post-metadata">

**Author:** ![sandra\_nz](https://avatars.discourse-cdn.com/v4/letter/s/eada6e/32.png) [@sandra\_nz](https://boards.straightdope.com/u/sandra_nz)\
**Post date:** [August 18, 2011, 1:33pm UTC](https://boards.straightdope.com/t/any-sharepoint-users-out-there/593145/3 "2011-08-18T13:33:30Z")

</div>

Good to know, thanks!