.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Excel fields linked to files in the document library do not update

Posted By:      Posted Date: September 20, 2010    Points: 0   Category :SharePoint

We are having an issue with an Excel spreadsheet that is linked to several Excel documents in a document library.  Mutliple staff members update several "sub" spreadsheets with information that is rolled up to the "master" spreadsheet.  Excel appears to behave correctly in that if I open both the sub and master spreadsheets in my Excel window at the same time, the data in master gets updated.  If I just open the master, I have stale data.  I'm not sure SharePoint is to blame here, so I'll post this in the Excel forums as well, but any information or experience anyone has had with this would be fantastic.

Thanks in advance for any help/advice!

View Complete Post

More Related Resource Links

Reg File Upload control to upload files from document library


In Field Upload control if we click browse button it allow us to search file in our hard disk but now as per my requirement as soon as user clicks ‘Browse’ button it should point to the document libraries and their files in site.Let me know how could i achieve this?

Thanks & Regards,


Document Library "export to spreadsheet" doesn't export all columns in Excel 2003

Hi, we are working with MOSS 2007, Infopath Forms Services, KPIs and Excel 2003. There is a view for some data of the Infopath forms which has to be exported to Excel by our users, but some columns are not exported - without any error message. If I try to export it to Excel 2007 everything is exported as expected, but our users have to use Excel 2003. Any idea?

Changing fields while updating an InfoPath Form to a SharePoint 2010 Document library

My document library has following EventReceiver: <?xml version="1.0" encoding="utf-8"?> <Elements xmlns="http://schemas.microsoft.com/sharepoint/"> <Receivers ListTemplateId="101"> <Receiver> <Name>EventReceiverDocumentLibraryItemUpdating</Name> <Type>ItemUpdating</Type> <Assembly>$SharePoint.Project.AssemblyFullName$</Assembly> <Class>EventHandling.EventReceiverDocumentLibrary</Class> <SequenceNumber>10000</SequenceNumber> </Receiver> </Receivers> </Elements> Updating a browser enabled InfoPath form in the document library fires following event: Public Overrides Sub ItemUpdated(ByVal properties As SPItemEventProperties) Try Me.EventFiringEnabled = False properties.ListItem("Lastname") = "Testperson" properties.ListItem.ParentList.ParentWeb.AllowUnsafeUpdates = True properties.ListItem.SystemUpdate(False) ' solution 1 properties.ListItem.Update() ' solution 2 properties.ListItem.UpdateOverwriteVersion() ' solution 3 properties.ListItem.ParentList.ParentWeb.AllowUnsafeUpdates = False Me.EventFiringEnabled = True MyBase.ItemUpdated(properties) Catch ex As Exception Me.EventFiringEnabled = True E

overwrite the files in document library from Explorer View ?

Hi Everyone, Suppose I have a document library which can be opened using the explorer view, what happened if someone uploads to this library by drag n drop into the library with same filename? What would be the final story of the file which is overwritten through drag n drop from Explorer view ? Thanks./* Infrastructure Support Engineer */

Indexing Document library which contains .RTF files

Hi All, I've just craeted a document library objects in my SharePoint site and then i imported several hundreds .RTF files into it, how and when can i perform search and compare of this files against each other ? Does MOSS 2007 SP2 Enterprise supports indexing .rtf files ? Thanks, AWT/* Infrastructure Support Engineer */

Moving files from one document library to another problem.

Hi, I have a strange problem with trying to move a number of files progammatically from one document library to another. I have a workflow running in sharepoint, which throughout the progress of the workflow, updates a word document stored in a document library, titled "CR".  Within the CR library there may also be a folder title "CR X" where x is the number of the document.  This folder contains any files which have been attached to the CR document.  I.E, excel files, pictures etc. When the workflow completes, the document should be moved to another document library called "Archived" which has a folder named after the year, i.e 2010, which inside that, contains a folder called the name of the document.  All the attached documents should also be moved to this folder. So for example, a document structure could be parentweb\parentsite\CR\CR 2.doc parentweb\parentsite\CR\CR 2\image.jpg parentweb\parentsite\CR\CR 2\image2.jpg Should, when the workflow completes end up looking like: parentweb\parentsite\Archived\2010\CR 2\CR 2.doc parentweb\parentsite\Archived\2010\CR 2\image.jpg parentweb\parentsite\Archived\2010\CR 2\image2.jpg. I have got the first part working fine, where the document is moved to the archive directory.  But I cannot move all the attachment files.  The loop I have to get the files and move them will wo

Document library hiding pdf files' tool bar

Hi all, I have a requirement that the Sharepoint pdf documents should have the toolbar hidden in order to prohibit users from downloading and printing the file. The only way I can do this is to create a content editor web part, using HTML to open the pdf file and add '#toolbar=0' after the pdf file name. I am wondering if I can also add '#toolbar=0' to the Sharepoint document library's pdf files? Thanks!

Querystring to determine what Document Library Folder's files to list?

First of all, any webpart that alllows you to list documents in a particular folder of a Document library? Second, possible to pass what folder to list via a query string to  that webpart ? Thanks.

Multiline text field in document library and item update from Word trouble

Hi I have faced a bit of odd problem. Here is the scenario: I have document library with text columns (multiple lines of text) that are set to unlimited length. I have a workflow that runs with Word documents (.docx) that stores information in XML to this field. Everything works perfectly until document is edited in Word and saved back to document library. After Word saves my document in document library, the multiline text field is "cutted", only 7 rows of text is saved to my field. I have tried hiding my text field, making it sealed or readonly, but still Word breaks my field. Funniest thing is that when editing document in Word, this field should not have any changes (meaning that I dont show my "long text field" in document information panel back in Word). I have tried also creating event handler to handle itemupdating event in document library where I switch spweb.parserenabled property to false and in itemupdated event I switch it back on. Also I have tried to remove all line changes from XML with no luck. This XML saving to long text field works perfectly with many other places but in this one environment this does not seem to work :( I am looking forward to any suggestions what to try next. I have been wondering about using the eventhandlers and trying to "protect" my text field with some logic but that is still just a thought.   T

URGENT: Document Library Content Type not inheriting some fields from parent Site Content Type


I have a situation that has foxed me!! I have a site level content type that has 8 fields... I use this to create more content types at the site level and use these in multiple Document Libraries (I have 40 doc libs).  This works fine for 38 of the libraries.  But for 2 of them... 2 of the columns are not showing up on the document libraries.  These are user lookups fields.  I am not sure why it's not working in these libraries only!  When I use the same content type in another library... the inheritance does not break for these fields!

Anyone please provide some guidance on this?  I am using WSS 3.0 and SPD to do workflows.

On another note... the content type has a template (in excel) attached to it.  When I create the content manually using the content type from the New menu option, the template is used... however, when I try to add it using an SPD workflow, it creates a blank template... the content type template is not being used.

Please help... I am in a fix and need to release this application today!!!

Sharepoint 2007 delay in files are not showing up in document library


When saving a file from ie. an email attachment into a sharepoint document library the files show up in explorer view of the document library but there is about a 20 minutes delay before they show up in the default view of the document library.  This is quite frustrating as because you can not see it there the users try to save as again. 

This seems to work correctly in our test sharepoint environment.  Does anyone have any ideas as where to start looking.


Managing Document Library files using Offce 2007 VBA


We have a farily large SharePoint site, (>20,000 Office documents), and we are running low on disk space.  I would like to write a VBA program that walks through the tree (including subsites) and deletes all the document library history files that are over 1 year old.  I can't seem to find a way to access the history files unless I open each document; opening each document would cause my program to take months to complete.  Does anyone know a way to get access to the history files using VBA without having to open the Office file whose history I want access to?  The only way I've found to access this history files is to use the DocumentLibraryVersions object, but it requires that I open the file (that I know of).  I have no problem walking the file tree and I have access to SharePoint Designer 2007, Excel 2007, and Word 2007 typelibs, object models, etc..  Due to policy restrictions in my company, I cannot install development tools on my machine, so I'm stuck with VBA.  Also, I won't be allowed to create a web service; although I can access one that already exists on our server in case any come with SharePoint.


P.S., I have lots of good VBA code that I've written over the last 15 years to do all kinds of tasks with Office and SharePoint that I'm happy to share if anyone can benefit from it.&

How to Programmatically Upload the files based on the current location in the document library?


how can programmatically to upload a file to document library based on the current location for example when i was inside the subfolders and click on the custom button in ribbon it should upload file to current location entered to document library not hardcoding the subfolders name 

Thanks in advance

how to extract the files from the document library using object model



I need to extract the files from the document library using object model in sharepoint 2007.

Can anyone help me.




Deploying files to a document library with your wsp (hopefully an easy one!)


Hey all,

I build a project to WSP and deploy to my solution, that all works beautifully. I now want to deploy some 'emailtemplates' for use throughout the site collection - the best way to do this seems to be as a document library. What do i need to do? Can i do it as a module? How do i specify where things end up? I'm really struggling to find links to help with this so i'm thinking it must be 'obvious' - at least to someone!

Many thanks,


Edit 1: Email templates are .xslt files

Deploying files to a document library with your wsp (hopefully an easy one!)


Hey all,

I build a project to WSP and deploy to my solution, that all works beautifully. I now want to deploy some 'emailtemplates' for use throughout the site collection - the best way to do this seems to be as a document library. What do i need to do? Can i do it as a module? How do i specify where things end up? I'm really struggling to find links to help with this so i'm thinking it must be 'obvious' - at least to someone!

Many thanks,


Edit 1: Email templates are .xslt files

Move SharePoint Document Library Files to Local Drive

How can I move files uploaded into a MOSS 2007 Document library to a local drive? I need to automate this as a job, not a one-time process. Can I use SSIS for it? File Systems Task works fine so long as I create a map drive to the portal. I have tried both the http address and the UNC path to the portal.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend