Does SharePoint support Excel spreadsheets linked to each other?

cruizer
  • Does SharePoint support Excel spreadsheets linked to each other? cruizer

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

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

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

Tags
excel
Related questions and answers
  • In our SharePoint solution we need a service which can search and index XML files. At this moment we are using FAST, but are there other tools / applications / solutions which are free and easy to integrate / customize within SharePoint 2007 ?

  • I am using SharePoint Server 2007 with collaboration portal template on Windows Server 2008. The default search address for a site is pointed to /SearchCenter/Pages/Results.aspx. Any ideas how to change the address to some other address? thanks in advance!

  • I have a two machine set-up, with MOSS 2007 installed on one server (Machine A), and SQL Server 2008 installed on the other (Machine B). In order to run SS Reporting Services in SharePoint integration mode on Machine B, I've read that I need to perform a minimal install of SharePoint on Machine B, and am wondering why. From a couple of error messages I see that it seems like Reporting Services in integration mode makes use of the SharePoint Object Model, but I haven't explored any further. So, purely just out of interest, why is it that I need to have a minimal SP install if my report

  • I am using SharePoint Server 2007 Enterprise with Windows Server 2008 Enterprise, and I am using publishing portal template. I am using SharePoint Designer 2007 to design pages. When I open the default.aspx under Pages sub-folder of a site, there are two options: Edit in Browser and Edit Page Layout. I want to know what are the differences between Edit in Browser and Edit Page Layout -- especially what is the function of Edit Page Layout, because when I select Edit Page Layout, WelcomeSplash.aspx opens in SharePoint Designer, other than default.aspx itself (very confused). thanks

  • I am using SharePoint 2007 Enterprise + Publishing portal template + Windows Server 2008. I am developing using VSTS 2008 + C# + .Net 3.5. I need to implement SSO (Single Sign On feature) with another site. The SSO protocol is like this, The other site will send me information like http://mysitename/default.aspx?Identity=abc or like http://mysitename/default.aspx (mysitename is the site which I... information (e.g. user name and email address) from the Identity variable; The actual user name, user profile (e.g. email address) and password are maintained by the other site; My site will manage roles

  • I am using SharePoint Server 2007 Enterprise with Windows Server 2008 Enterprise. I have the following requirements about `Task Management and want to know whether SharePoint Server 2007 can implement such feature. And if not, what kind of Microsoft or non-Microsoft product could achieve such goals (and could integrate with SharePoint Server 2007). I prefer Microsoft product because I have requirement to integrate task management feature into SharePoint, and I think using Microsoft product is easier for integration with SharePoint. :-) Requirements are, For Task Management, task

  • What antivirus products have you used in SharePoint 2007 (WSS v3 and MOSS 2007) implementations? I've had quite a bit of experience with Forefront Security for SharePoint and its my default recommendation, but it looks like there's other vendors out there that are finally offering coverage for SharePoint 2007, instead of the prevision version of the platform. Do you think its better to use the same vendor for SharePoint AV that is running for the OS? What I mean is if McAfee is protecting Windows Server is it better to use their solution for SharePoint to keep things consistent from an AV

  • I am using SharePoint Server 2007 Enterprise with Windows Server 2008 Enterprise. I am using SharePoint Designer 2007 to open default.aspx under Pages sub-folder (selecting edit page layout in SharePoint designer 2007) of a site, but welcomesplash.aspx displays other than default.aspx itself, why?

  • I am working with a SharePoint Server 2010 survey that contains some questions about allow fill-in responses. Is there a simple way to change the wording of these fill-in questions? Instead of "Specify your own value," I would like them to say something along the lines as "Other" (per project sponsor request). I found this in regards to the WSS 3.0 and MOSS 2007 customization: However, it seems to me that there should be an easier way to change the wording of this question without having to edit the default master page.

Data information