Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Is it possible with Office 2007 + SharePoint 2007 to have a spreadsheet uploaded to a SharePoint document library having dependencies/links to other spreadsheets also stored in SharePoint? Thanks...

share|improve this question

3 Answers 3

Actually I'm pretty sure that this is not supported according to http://office.microsoft.com/en-us/sharepointserver/HA101054571033.aspx specifically under the 'Unsupported Features' section that lists 'External references to linked workbooks'.

share|improve this answer
1  
The URL doesn't resolve for me. I am finding the page at msdn.microsoft.com/en-us/library/ms496823(office.12).aspx. However, as noted by Brian Hayes, this page is referring to Excel Services which is different. –  Mike H Jun 11 '10 at 3:55

This should work, but I believe it is easier to move the data to Sharepoint and handle it in there. You can still use Excel for charts and pivot table stuff, but use Sharepoint to store the data.

share|improve this answer
    
+1. This could be a better option. The killer of course would be if there is extensive logic in the cells. It's worth noting though, that some auditors regard data in Excel as unreliable as it's too easily edited and difficult / impossible to trace to a source. –  Mike H Jun 11 '10 at 3:58

The link you posted Michal, is to Excel Services which would display it as a web based data format. I believe he is using SharePoint to store the document, and access another Excel doc in SharePoint. So I don't think those "Unsupported Features" apply.

Please correct me if I'm wrong.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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