Any SharePoint users out there?

Factual Questions
1

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.

2

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.

3

Good to know, thanks!