Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Linking to documents within SharePoint

  Asked By: Umesh    Date: Sep 15    Category: Sharepoint    Views: 877

If this has already been discussed in the forum, I apologize.

My company is in the process of moving some of our files to SharePoint
Portal Server 2003. We have been successful in moving documents onto
the server and using the document library, but there is one thing that
is plaguing us. We have an Excel file that creates charts for us based
on information from a pivot table in another Excel file. When linking
the chart file back to the parent file, there is no problem until we
try to update the parent file. Since the file opens as read only, it
appears that when we save the new file on top of the old one it breaks
the links we need. Is there any way we can get these files to not open
in read only?



3 Answers Found

Answer #1    Answered By: Brittni Harding     Answered On: Sep 15

I have run into the exact same problem when exporting
Quickbooks reports to an Excel workbook and trying to link the Excel
workbook to Sharepoint. If you enter your data on the Sharepoint side
you're fine, if you export QB's data to a parent Excel File (which is
what I want to do) you actually have to delete the Sharepoint page and
recreate it and relink it, it won't allow you to overwrite! It's kind of
backwards from my point of view since we want to use Sharepoint to view
and share data and not to input data, but I havn't been able to find a
good workaround at least as far as Quickbooks to Excel to Sharepoint
goes. I've tried sending the data to Access and SQL as well and While
reaching some success with the SQL method using a third party tool, it
is much too complex to remap the desired fields and columns to make it
worth the effort and it has to be redone every time you reboot the

Excel does have controls for auto-republishing to html webpages but
that's not what we envisioned.

I'd love to hear any ideas or methods on this. Asside from getting Great

Answer #2    Answered By: Aayush Koli     Answered On: Sep 15

I know it says somewhere in the documentation that a few things aren't
supported in sharepoint. From memory, I'm thinking it was .mdb files
(access databases), multi-file html web pages (use .mht instead), and
embedded linking  in Word or Excel.

Answer #3    Answered By: Bradford Norman     Answered On: Sep 15

Ya I know... Like everything else it's that one little thing you need to
make it all gel and come together that just doesn't work. lol

I'd get Great Plains if I had 20k sitting around but I don't and the
smaller versions like business manager and all of that don't have user
defined fields.
It's always something I guess.

Didn't find what you were looking for? Find more on Linking to documents within SharePoint Or get search suggestion and latest updates.