Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Excel Links in Sharepoint

  Asked By: Brenda    Date: Feb 16    Category: Sharepoint    Views: 11055

I have two spreadsheets which were linked using relative paths in my
old file system. These have now been moved to web folders within
Sharepoint Portal Server and the paths seem to have changed to full
paths. eg

http://server/workspace/Folder name/Folder name/Folder
name/[Assessed%20Cost.xls]Externals Summary'!E12

This has the effect that the updates I make to one spreadsheet are
only shown on the other when I close both down and reopen them. This
is no use for the way I work with these spreadsheets and I am trying
to find a way to either change the paths back to being relative or
force excel to update as I make the changes.

I have tried changing the paths back but excel immediately returns
them to the example above. I have also tried clicking "update now" in
the Edit/Links menu but this has no visible effect. The spreadsheets
are still linked correctly as I can see the changes when I close down
and reopen.

Share: 

 

7 Answers Found

 
Answer #1    Answered By: Sammie Lancaster     Answered On: Feb 16

Not entirely sure about this, but you may want to ensure that these are both
stored in standard folders  (and not enhanced folders).... I've been led to
believe that these act the same as a shared network folder.

 
Answer #2    Answered By: Aron Kirk     Answered On: Feb 16

They are definitely not enhanced folders. The problem seems to be
that the files are now stored in a web  based system  and have to show
the full path to recognise the file. It is very frustrating. Thanks
anyway. I will keep plugging away!

 
Answer #3    Answered By: Hailey Clark     Answered On: Feb 16

All documentation on SPS confirms that it doesn't support what are referred
to as 'compound' files i.e. files with links  to other files in enhanced
folders. I have found that linked excel  files produce some surprising
(read: usually annoying and painful) results in SPS, and I don't recommend
them to my users. Put them in standard folders, and if you need to publish
them publish them in the enhanced folders  with the links removed.

 
Answer #4    Answered By: Nisarg Shahane     Answered On: Feb 16

The confusing thing is that they are in standard folders  already and
it only seems to be effecting some files, not all. I think the
probelm may lie in the way they have been linked.

Thank you all for your suggestions. I will let you know if I get to
the bottom of it.

 
Answer #5    Answered By: Bryan Leland     Answered On: Feb 21

I ran into a similar problem. I had multiple Excel files linked together, but only select formulas were not updating. I found that one file was trying to reference a combination of the SharePoint site and the old network folder structure. It was like it created it's own link (very strange). Looking into more I found and obscure formula with and old link that was over looked. Fixing this fixed all my other problems.

Had this happen in two different circumstances too. It appears that for some reason one incorrect formula/link can mess with everything else.

Hope this helps.

 
Answer #6    Answered By: Jonathan Kruger     Answered On: Dec 01

Hi. Has anyone found the solution to this problem? I'm really battling to fix it. I would really appreciate help.

 
Answer #7    Answered By: Jonathan Kruger     Answered On: Dec 01

Hi. Has anyone found the solution to this problem? I'm really battling to fix it. I would really appreciate help.

 
Didn't find what you were looking for? Find more on Excel Links in Sharepoint Or get search suggestion and latest updates.




Tagged: