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...

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'.

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.

  • +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.

Your Answer

 
discard

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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